| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract 10 months from a Speficic Date
I have a spreadsheet with an Eligibility Date for Upgrades, which is 10
months after it was upgraded. I need to determine when the device was originally updated. To do this, I need to subtract 10 months from the Eligibility Date. I've used the below formula but receive the #VALUE error. =DATE(YEAR(Q3),MONTH(Q3)-6,DAY(Q3)) Is there another formula I need to use to retrieve 10 months before the eligibility date? This eligiblity date is a vlookup from another excel spreadsheet, does this factor in when having the specific formula? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200905/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Subtract 6 months off a date in excel | Excel Discussion (Misc queries) | |||
| How do I subtract/add a known number of days/months from a date? | Excel Worksheet Functions | |||
| subtract years and months (as in ages) from another age | Excel Discussion (Misc queries) | |||
| Subtract 6 months | Excel Worksheet Functions | |||
| Subtract MM/DD/YYYY and get # months | Excel Discussion (Misc queries) | |||
Threaded Mode
