Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    date calculation (97 or 2000)

    Hi all,
    I don

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: date calculation (97 or 2000)

    You can do this several ways, depending on how much work you want to spend on it:
    1) use datavalidation in 3 cells (in worksheet)
    1st with list for months
    2nd with numbers 1-31
    3rd with numbers 2003-2010
    Only problem is handling the number of days to match year/month

    2) use comboboxes and FORCE the year, then month selection first and second and then have the range change for the days to match. COuld be done directly in workbook or in userform

    3) userform with calendar or one of the other "date chooser" types of controls.

    If you choose individually the date is:
    =datevalue(year,month,day)
    and 343 days later is:
    =datevalue(year,month,day) +343

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: date calculation (97 or 2000)

    Hi Steve, thanks for getting back to me. I have attached a document on what I have done. and the problems.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: date calculation (97 or 2000)

    See attached modified version. Instead of the month name, it uses the month number, and the DATE function to get the date from the year, month and day numbers.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: date calculation (97 or 2000)

    You only actually need to do a lookup for the year. Both the month (which you used) and the day (which you looked up) can directly use the linked cells.

    Steve

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: date calculation (97 or 2000)

    You're right, of course. I was lazy and applied only the minimum modifications necessary to get the date.

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: date calculation (97 or 2000)

    My suggestion was more geared to "Buckshot".

    I figured you knew this. Just looking for ways to simplify.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •