Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date minus 3 months
Hi Everyone,
I adapted this formula from the 'date plus 1 month' question. =MIN(DATE(YEAR(D17),MONTH(D17)+{-1,-3},DAY(D17)*{0,1})) The only problem is the {0,1} in the days. When I input 7/31/06 into D17, I get 5/1/06 as my result, when I want to get 4/30/06. Also when I input 5/31/06 into D17, I get 3/3/06, when I want to get 2/28/06. Any suggestions? Also, I have no idea what those {} brackets are doing...anyone have an explanation? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manipulating dates (was Add 6 months to a date) | New Users to Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
How to Highlight the date if it is within 3 months from now | Excel Worksheet Functions | |||
date (minus) date = working days diff | Excel Discussion (Misc queries) | |||
Use a calc to figure sum in months using date fields but numeric r | Excel Worksheet Functions |