| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to reduce date by 3 months
Hello, I need a reasonably simple function that will look at a date (which
will always be the 1st of a month) and return the equivalent date a specified number of months earlier. e.g we give it the 1st of Feb 03, and it returns the 1st of November 02. Ideally I wouldn't have to use a user-defined VBA function, but find a way to do it using the existing date functions. VBA is a last resort for this spreadsheet. Thanks |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to reduce date by 3 months
=EDATE(A1,-3)
requires the Analysis Toolpak (ATP) add-in. Or... =DATE(YEAR(A1),MONTH(A1)-3,DAY(A1)) without ATP. "mike h" wrote in message ... Hello, I need a reasonably simple function that will look at a date (which will always be the 1st of a month) and return the equivalent date a specified number of months earlier. e.g we give it the 1st of Feb 03, and it returns the 1st of November 02. Ideally I wouldn't have to use a user-defined VBA function, but find a way to do it using the existing date functions. VBA is a last resort for this spreadsheet. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3 months prior and 3 months post a date | Excel Worksheet Functions | |||
| Formula to change date to reduce bal | New Users to Excel | |||
| About calculate months between two date (date function) | Excel Discussion (Misc queries) | |||
| Calculate date 28 days from now if hours reduce | Excel Worksheet Functions | |||
| excel function reduce and increase numbers | Excel Worksheet Functions | |||
Linear Mode
