Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Date in Month
I have a list of 3,000 dates in a column, and I want to
delete every row in the column except the last day of each month in the list. Unfortunately, the last day of the month in the list may not be the exact end of the month. In the example below, I want to delete every row except the one containing 9/29/2003: 9/27/2003 9/28/2003 9/29/2003 10/2/2003 10/3/2003 I can't use EOMONTH to identify the row because the end of September is 9/30, not 9/29. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count month when date is in day/month/year format | Excel Worksheet Functions | |||
Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
=VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MONTH(date)-6, MON | Excel Worksheet Functions | |||
Month to date sales - reset in new month??? | Excel Worksheet Functions |