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

1. ## 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,

2. ## Re: calculate the number of days in a month through 'Month Name'

Try

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

Or

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

A1="April" (without quotes)

3. ## Re: calculate the number of days in a month through 'Month Name'

Try this
Formula:
`Please Login or Register  to view this content.`

 v A B 1 April 30

4. ## Re: calculate the number of days in a month through 'Month Name'

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

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1