Hi,

Need urgent help, i am working on the salary, what i am trying to do is Highlight the Total Days exceed of the Month, the mouth name which i enter manually.

I am trying this formula in conditional formatting to highlight the Present days if it exceed from the days in month. But the problem is their the below formula works with month number, not with month name. 

=DAY(DATE(year, month number + 1, 1) -1)
i want formula (with mouth name) something like this

=DAY(DATE(2017, April + 1, 1) -1)
I hope what i am trying to accomplish is possible or their any other way around.

any kind help and guidance will be appreciated

Best,