How to add a Date

  • Thread starter Thread starter JimS
  • Start date Start date
Try this:

=A1 + 1

format the cell as a date. I assume your dates are in dd/m/yy format.

Hope this helps.

Pete
 
One way

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

Of course if you have 01/31/09 in A1 then you will get
a date in March

--


Regards,


Peo Sjoblom
 
You're assuming the European way of writing dates. The OP wasn't clear.
The answer could also be A1 + 31, or A1+30.

Craig
 
There is no European way of writing dates, Pete assumed it was UK.


--


Regards,


Peo Sjoblom
 
A1+31 or A1+30 doesn't account for February which is 28 or 29 days. To add
one month:

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

--
Steve

You're assuming the European way of writing dates. The OP wasn't clear. The
answer could also be A1 + 31, or A1+30.

Craig

Pete_UK wrote:
Try this:

=A1 + 1

format the cell as a date. I assume your dates are in dd/m/yy format.

Hope this helps.

Pete


If I have 11/2/08 in A1, what formula would I put into A10 to get
12/2/08, etc?

Thanks
 
Hi,

Maybe a little easier:

=EDATE(A1,1)

EDATE is an analysis toolpak function so it must be attached - Tools,
Add-ins, and check Analysis ToolPak.
 
Back
Top