Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Vermilion, Ohio, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dates in excell (Office XP)

    How do I add say 30, 60 , or 90 days to a date. example cell a1=02/25/03, i want cell b1 to show the date 30 days from 02/25/03, cell c1 to show the date 60 days from 02/25/03, and cell d1 to show the date 90days from 02/25/03.

    then i would like cell a2 to have a different date and the b2,c2, and d2 cells to show 30,60,90,days from the date in cell a2. etc.

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

    Re: Dates in excell (Office XP)

    In cell B1, enter the formula =A1+30
    In cell C1, enter the formula =A1+60
    In cell D1, enter the formula =A1+90

    Enter dates in A2, A3, etc. Then select B11 and double click the fill grip (little black square in the lower right corner of the selected range). Excel will fill down the formulas, adapting them as needed.

    Explanation: dates in Excel are actually just numbers: the number of days since December 31, 1899. So you can simply add 30, 60 or 90 to a date.

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Vermilion, Ohio, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dates in excell (Office XP)

    Thanks;

    It works fine.

Posting Permissions

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