calculate the number of days in a month through 'Month Name'

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.

Please Login or Register  to view this content.

i want formula (with mouth name) something like this

Please Login or Register  to view this content.

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,

Try

=DAY(DATE(2017, MONTH("April" &0)+1, 1) -1)

Or

=DAY(DATE(2017, MONTH(A1 &0)+1, 1) -1)

A1="April" (without quotes)

Bingo, Perfect Works Great

Thank you soooo much 'JohnTopley' & 'AlKey' i am relly great full to you all Experts

Best,

Threat Marked as SOLVED & Reputation Added