How to add a Date

[JimS]

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

Thanks

 

[Pete_UK]

Try this:

=A1 + 1

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

Hope this helps.

Pete

 

[Peo Sjoblom]

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

 

[JimS]

That did the trick. Thanks

 

[Craig Schiller]

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

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom

 

[AltaEgo]

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

 

[ShaneDevenshire]

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.