| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculate month-end date from date in adjacent cell?
Hi,
I need to be able to enter a date in a cell and have the cell next to it return the corresponding month-end date. I'm sure it's simple but I couldn't find a dedicated function. e.g A1 = 03/01/2005 A2 = 31/03/2005 (calculated) or A1 = 17/021/2005 A2 = 28/02/2005 (calculated) etc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I automatically calculate YTD numbers by changing a date? | Excel Worksheet Functions | |||
| Lookup the month in a date string 01/03/05 | Excel Worksheet Functions | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) | |||
| calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
Threaded Mode
