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.

H.

Howdy!

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:

=A2+10

Format as needed.