| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calendar/Date Calculations
Given a base date such as 10/1/2006, how do you return a date knowing the
number of months previous to the base date? Using this for a project plan and want to return the value for A-20 where A is the base date and 20 is the number of months before the base date. Thanks for your help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calendar/Date Calculations
If base date is in A1, 20 months before base date is:
=date(year(a1),month(a1)-20,day(a1)) -- Regards, Fred "Rob" wrote in message ... Given a base date such as 10/1/2006, how do you return a date knowing the number of months previous to the base date? Using this for a project plan and want to return the value for A-20 where A is the base date and 20 is the number of months before the base date. Thanks for your help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calendar/Date Calculations
Try this:
=EDATE(A1,-20) Required Analysis ToolPak Add-Ins "Rob" wrote: Given a base date such as 10/1/2006, how do you return a date knowing the number of months previous to the base date? Using this for a project plan and want to return the value for A-20 where A is the base date and 20 is the number of months before the base date. Thanks for your help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calendar/Date Calculations
Perfect! Just what I was looking for!
"Teethless mama" wrote: Try this: =EDATE(A1,-20) Required Analysis ToolPak Add-Ins "Rob" wrote: Given a base date such as 10/1/2006, how do you return a date knowing the number of months previous to the base date? Using this for a project plan and want to return the value for A-20 where A is the base date and 20 is the number of months before the base date. Thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| order of calculations in Excel | Excel Worksheet Functions | |||
| Calculations in French - Clarification | Excel Discussion (Misc queries) | |||
| complex calculations | Excel Discussion (Misc queries) | |||
| Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
| time interval calculations in excel | Excel Discussion (Misc queries) | |||
Linear Mode
