View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah (OGI) Sarah (OGI) is offline
external usenet poster
 
Posts: 128
Default Summarise the date by month

I have a list of dates in ascending order.

In another column, I want to summarise the dates according to month, but
only for the first instance of that month, i.e. for the first Jan date
listed, I want the adjacent cell to show 'January', but I don't want the word
'January' to show for all Jan dates.

Any ideas?