Date Function
 

I would like to find a function that will take the date in one column and
tell me what date is 4 months after that date - any thoughts

Date Function
 

=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1))

--
Gary''s Student - gsnu200770

Date Function
 

If your date is in A1 then =EDATE(A1,4) might do what you want. You will
need to have the Analysis Tookpak installed for versions of Excel prior to
2007.
EDATE is documented in help under date functions.

Tyro

"Sarah" wrote in message
...
I would like to find a function that will take the date in one column and
tell me what date is 4 months after that date - any thoughts

Date Function
 

=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sarah" wrote in message ...
|I would like to find a function that will take the date in one column and
| tell me what date is 4 months after that date - any thoughts

Date Function
 

Another way which doesn't need the ATP:

=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1))

Hope this helps.

Pete

On Feb 22, 4:12*pm, "Tyro" wrote:
If your date is in A1 then =EDATE(A1,4) might do what you want. You will
need to have the Analysis Tookpak installed for versions of Excel prior to
2007.
EDATE is documented in help under date functions.

Tyro

"Sarah" wrote in message

...



I would like to find a function that will take the date in one column and
tell me what date is 4 months after that date - any thoughts- Hide quoted text -

- Show quoted text -