Conditional Format and Countif dates that are not the last day of the month

[bobtheboffin]

Hi all,

I've got a list of dates (throughout the year) which should be the last date of their respective month (31st, 30th, 28th/29th for Feb). There are, however a number of dates which aren't the last day of a month e.g. 3rd, 11th, 21st etc. and I want to be able to Conditionally Format the list to highlight these in red, I also want to be able to count how many dates are not the last day of the month.

Is it possible to do either of these things?

Many thanks for your help.

 

[Special-K99]

=(A1<>EOMONTH(A1,0)

Select A1

Conditional Formatting
New Rule
Use a formula to determine...

=(A1<>EOMONTH(A1,0)

Format as red
Use Format painter (paintbrush icon) to copy to other cells