S
Sarah
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
tell me what date is 4 months after that date - any thoughts
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1))
T
Tyro
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
need to have the Analysis Tookpak installed for versions of Excel prior to
2007.
EDATE is documented in help under date functions.
Tyro
N
Niek Otten
=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1))
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
|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
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
|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
P
Pete_UK
Another way which doesn't need the ATP:
=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1))
Hope this helps.
Pete
=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1))
Hope this helps.
Pete