| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Function
=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1))
-- Gary''s Student - gsnu200770 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date function in ACCRINTM requires date format not available | Excel Worksheet Functions | |||
| MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Hybrid Mode
