Date formula

G

Goyo el Noyo

In excel I'm going to input a date in a cell, and the next column I need to
put a formula that would add 30 calendar days to that date?

Any suggestions are appreciated
thank you
 
R

Ron Coderre

Try this:

A1: (a date)
B1: =A1+30
Format that cell as a Date

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
B

Bernard Liengme

=A1+30 will work if A1 has a real date (entered as 1/31/2008 or 31/1/2008
depending if use you US or rest-of-world format for date)
best wishes
 
K

Kevin B

The following example uses cell A1 as the cell containing the original date.

In cell B1 put the following formula:

=A1+30

Adjust the cell address as needed.
 
Top