Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008

    Unanswered: Adding days to dates ?

    Hi Folks,

    I've got a list of dates that I need to add a certain number of days to.

    They are in a date format.

    How would I add 10 days to 01/01/2000 automatically ?

    Any ideas ? Of course there is more than one to be done.


  2. #2
    Join Date
    Oct 2003

    Dates are formatted as dates, but Excel sees them as numbers (serial numbers). Thus, today is 39524. So, if your date is in A2 (as formatted date, not serial number), you can put in B2 this formula:


    Format as needed.
    Last edited by shades; 03-17-08 at 11:50.
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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