November 7th, 2003, 04:46 AM
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 !!!
November 7th, 2003, 05:13 AM
If the data is actually stored in Date format, the easiest way ,ight be to change the Date Display setting under Regional Settings in Control Panel.
November 7th, 2003, 05:22 AM
Assuming Microsoft Excel.
- Open a new sheet.
- Highlight cells A1 and A2. Right-click them and select Format Cells... Under the Number tab, select Date in the Category window and 03/04/97 (or similar) in the Type window then click OK.
- Right click cell A3 and select Format Cells... Under the Number tab, select Number in the Category window, set 0 Decimal places and click OK.
- Type the following in cell A1:
- Type the following in cell A2:
- Type the following in cell A3:
- The results you now see in cell A3, i.e.,
is the difference, in days, between the two dates in cells A1 and A2.
November 7th, 2003, 07:22 AM
Thank U jdc2000 & Vernon Frazee !!!
I did'nt quite understand what jdc2000 said !!! But Vernon Frazee's method worked for me !!!
So Thank U guys
November 8th, 2003, 06:15 AM
You're more than Welcome.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)