View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Needhelp Needhelp is offline
external usenet poster
 
Posts: 1
Default 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?