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

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)

"Goyo el Noyo" wrote in message
...
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

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

Regards
FSt1

"Goyo el Noyo" wrote:

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

=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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Goyo el Noyo" wrote in message
...
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

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.
--
Kevin Backmann


"Goyo el Noyo" wrote:

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