Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Fort Worth, Texas, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating a date (Excel 2002)

    Can Excel calculate and display a date when it is given one date and a number (of days, in a cell) to subtract from it?
    Thanks - - - Sher

  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: Calculating a date (Excel 2002)

    Yes. the date + or - the days will give you the date that many days before or after:

    =today()- 4
    is equal to the date 2/20/2004

    Or even:
    =A1 - A2
    if a1 has the date of interest and A2 has the number of days before.

    Steve

  3. #3
    Star Lounger
    Join Date
    May 2002
    Location
    Fort Worth, Texas, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating a date (Excel 2002)

    <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> Thank you. Apparently I kept getting an error because I was referring to an empty cell! Since I hadn't tried doing this in Excel before, I assumed it was Excel -- but it was me!!
    Thanks - - - Sher

Posting Permissions

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