-
November 7th, 2003, 05:46 AM
#1
Boolean Date?
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
-
November 7th, 2003, 06:13 AM
#2
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, 06:22 AM
#3
Assuming Microsoft Excel.
Instructions:- 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:
=date(2003,01,01)
- Type the following in cell A2:
=date(2003,11,07)
- Type the following in cell A3:
=+a2-a1
- The results you now see in cell A3, i.e.,
310
is the difference, in days, between the two dates in cells A1 and A2.
-
November 7th, 2003, 08:22 AM
#4
ThnakX
Hi,
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
rgds
Shanthi
-
November 8th, 2003, 07:15 AM
#5
You're more than Welcome.
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|