New case of Month Formulas

A

ahmed

I need to put name of month in cell and I get for anther cell total days of
month

For example:
In Cell A1 July
In cell B1 the result showing 31 total days of July

In Cell A2 February
In cell B2 the result showing 28 total days of February

What formula for this case?

i search through discussion group but i did not found it

any help
Thanks
 
A

ahmed

thanks bpeltzer

i do not want to use vlookup.

i want to input month name in cell and get number of total days at anthor
cell auto.
simple formula
 
R

Ragdyer

You would need to enter an XL recognized date, *not* just a text month
entry.

For example, *any* date containing the month in question, like say for March
in A1:
3/1

Then in B1, try this formula:

=TEXT(DATE(YEAR(A1),MONTH(A1)+1,0),"d")
 
Top