Add 45 days to a date....
 

I am brand new to Excel, have only inputted information and corrected issues
if a formula goes off... I've never had to start from scratch until today.
I need something that should be very simple, but I haven't been able to
figure it out.
I am trying to have a date automatically imputted into a cell that is 45
days later than a manually entered date in a previous cell... example.
I would enter 1/01/10 in E3 and I would want the date 2/15/10 to show up in
F3.. 2/15/10 being 45 days after 1/1/10. So, any time I entered a date into
the E column, a date 45 days later would show up in the F column. I hope
that makes sense and any help would be appreciated as I have no idea what I
am doing... it's Excel 2003.

Thanks!

Add 45 days to a date....
 

hi
a date is just a number that is formated to look like a date so all you have
to do is add 45 to the date.
in E3, enter 1/1/10
in F3, enter =E3+45
results will be 2/15/10

that should do it.

regards
FSt1

"ARR" wrote:

I am brand new to Excel, have only inputted information and corrected issues
if a formula goes off... I've never had to start from scratch until today.
I need something that should be very simple, but I haven't been able to
figure it out.
I am trying to have a date automatically imputted into a cell that is 45
days later than a manually entered date in a previous cell... example.
I would enter 1/01/10 in E3 and I would want the date 2/15/10 to show up in
F3.. 2/15/10 being 45 days after 1/1/10. So, any time I entered a date into
the E column, a date 45 days later would show up in the F column. I hope
that makes sense and any help would be appreciated as I have no idea what I
am doing... it's Excel 2003.

Thanks!

Add 45 days to a date....
 

Dates are stored as the number of days since 0-Jan-1900, so you can
simply add 45 to a date to get the date 45 days hence. E.g.,

=A1+45

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]


On Wed, 27 Jan 2010 13:58:11 -0800, ARR
wrote:

I am brand new to Excel, have only inputted information and corrected issues
if a formula goes off... I've never had to start from scratch until today.
I need something that should be very simple, but I haven't been able to
figure it out.
I am trying to have a date automatically imputted into a cell that is 45
days later than a manually entered date in a previous cell... example.
I would enter 1/01/10 in E3 and I would want the date 2/15/10 to show up in
F3.. 2/15/10 being 45 days after 1/1/10. So, any time I entered a date into
the E column, a date 45 days later would show up in the F column. I hope
that makes sense and any help would be appreciated as I have no idea what I
am doing... it's Excel 2003.

Thanks!

Add 45 days to a date....
 

Thank you so much!!! I was making it way more complicated than I needed to!

"FSt1" wrote:

hi
a date is just a number that is formated to look like a date so all you have
to do is add 45 to the date.
in E3, enter 1/1/10
in F3, enter =E3+45
results will be 2/15/10

that should do it.

regards
FSt1

"ARR" wrote:

I am brand new to Excel, have only inputted information and corrected issues
if a formula goes off... I've never had to start from scratch until today.
I need something that should be very simple, but I haven't been able to
figure it out.
I am trying to have a date automatically imputted into a cell that is 45
days later than a manually entered date in a previous cell... example.
I would enter 1/01/10 in E3 and I would want the date 2/15/10 to show up in
F3.. 2/15/10 being 45 days after 1/1/10. So, any time I entered a date into
the E column, a date 45 days later would show up in the F column. I hope
that makes sense and any help would be appreciated as I have no idea what I
am doing... it's Excel 2003.

Thanks!

Add 45 days to a date....
 

"ARR" wrote in message
...
I am brand new to Excel, have only inputted information and corrected
issues
if a formula goes off... I've never had to start from scratch until today.
I need something that should be very simple, but I haven't been able to
figure it out.
I am trying to have a date automatically imputted into a cell that is 45
days later than a manually entered date in a previous cell... example.
I would enter 1/01/10 in E3 and I would want the date 2/15/10 to show up
in
F3.. 2/15/10 being 45 days after 1/1/10. So, any time I entered a date
into
the E column, a date 45 days later would show up in the F column. I hope
that makes sense and any help would be appreciated as I have no idea what
I
am doing... it's Excel 2003.

In F3, do =E3+45, and format as date.