Date formula

[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

 

[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)

 

[FSt1]

hi
if the date was in A1 then in B! enter
=A1+30
format as date

Regards
FSt1

 

[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

 

[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.