| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date arithmetic: adding 1 month to prior end of month date
That does it. Thanks very much.
"SteveG" wrote: manxman, You could use, =EOMONTH(A1,1) Where A1 = your start date. You need the Analysis ToolPak installed to use the EOMONTH function. Tools, AddIns, select Analysis ToolPak and click OK. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=561577 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding specific cells based on a corresponding date | Excel Worksheet Functions | |||
| Formula = Today's date + 1 month | Excel Worksheet Functions | |||
| Get month from date | Excel Discussion (Misc queries) | |||
| Pulling a date in the current month | Excel Worksheet Functions | |||
| Return the end of month date from a date | Excel Worksheet Functions | |||
Threaded Mode
