Summarise the date by month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
It's a bit of a cheat, but you can give the right appearance with conditional
formatting. Where your dates are in column A, put the formula

=DATE(YEAR(A2),MONTH(A2),1) etc. in column B.

Then conditionally format the cell in column B3 as follows

Cell Value is Equal To =B2

and set Font to White on that condition

Finally paste the format onto the rest of column B.
 
B2 =TEXT(A2,"mmmm")
B3 =IF(MONTH(A3)=MONTH(A2),"",TEXT(A3,"mmmm"))

copy from B3 down as far as needed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
changin date dd/mm/yy into Month 2
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
2 dimensional date sort 1
Pivot tables 3
Summarising Data 5
Excel PRICE function: How does it compute Issue Date of the Security 5
Update cell value based on name and specific date 1

Back
Top