Boolean Date?
Results 1 to 5 of 5

Thread: Boolean Date?

  1. #1
    Join Date
    May 2003
    Location
    Leeds
    Posts
    107

    Angry 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


  2. #2
    Join Date
    Feb 2000
    Location
    Idaho Falls, Idaho, USA
    Posts
    12,559
    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.

  3. #3
    Join Date
    Feb 2000
    Location
    26.03N 80.14W
    Posts
    9,410
    Assuming Microsoft Excel.

    Instructions:
    1. Open a new sheet.
    2. 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.
    3. 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.
    4. Type the following in cell A1:

      =date(2003,01,01)
    5. Type the following in cell A2:

      =date(2003,11,07)
    6. Type the following in cell A3:

      =+a2-a1
    7. 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.
    Vernon Frazee, Microsoft MVP (Windows - Shell/User)

    Defenses Up!
    Tip: When prompted for a password, give an incorrect one first. A phishing site will accept it; a legitimate one won't.


    Inside Spyware: A Guide to Finding, Removing and Preventing Online Pests


    If you don't keep up with security fixes, your computer|network won't be yours for long.

  4. #4
    Join Date
    May 2003
    Location
    Leeds
    Posts
    107

    Smile 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

  5. #5
    Join Date
    Feb 2000
    Location
    26.03N 80.14W
    Posts
    9,410
    You're more than Welcome.
    Vernon Frazee, Microsoft MVP (Windows - Shell/User)

    Defenses Up!
    Tip: When prompted for a password, give an incorrect one first. A phishing site will accept it; a legitimate one won't.


    Inside Spyware: A Guide to Finding, Removing and Preventing Online Pests


    If you don't keep up with security fixes, your computer|network won't be yours for long.

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
  •