Setting up a date formula in a spreadsheet

[Guest]

I'm trying to enter specific dates in an excel spreadsheet and create a code
(for adding a specified # of days to the existing date) so that I do not have
to type in the entire date every time. OK that's confusing. For example, if
I enter 9/15/04 and in the next cell I want to make the date 30, 45 or 60
days later. Is there a formula I can enter so that if I type in "30" it
automatically adds 30 days to 9/15/04 and automatically enters "10/15/04"
instead of me having to type out "10/15/04"??? Hope that's a bit clearer. The
main problem is I want to be able to assign a number code (30 for 30 days, 45
for 45 days, etc.) so all I have to do is type in the desired number of days
and have the date automatically updated.

 

[Jay]

I'm trying to enter specific dates in an excel spreadsheet and create

a code (for adding a specified # of days to the existing date) so that
I do not have to type in the entire date every time. OK that's
confusing. For example, if I enter 9/15/04 and in the next cell I want
to make the date 30, 45 or 60 days later. Is there a formula I can
enter so that if I type in "30" it automatically adds 30 days to
9/15/04 and automatically enters "10/15/04" instead of me having to
type out "10/15/04"??? ...

One way:

A1 has the original date; for example, 09/15/04, formatted as a date

B1 has how many days to add; for example, 40

C1 has the result, "=A1+B1" (without quotes), formatted as a date