Hi,

Can anyone tell me whether it is possible to generate boolean date format(yyyyddd or dddyyy) from normal date format (ddmmyy,mmddyy or yymmdd) in a spread sheet?

Actually I have a spread sheet with ddmmyy date format on it. I need to convert them to boolean date format in order to calculate no of days using the system dats.

If I can get this spread sheet boolean date format then I would be able to create a macro to obtain the no of days due.

Please let me know if you have any idea to do this !!!

Thanks
Shanthi