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

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

"bpeltzer" wrote:

Create a table with the month name in column A and the # days in column B.
Suppose this is on Sheet2. Then =vlookup("June",Sheet2!A:B,2,0) would return
the cell from column B in the same row where you have June in column A.
Alternately, if you have a particular date and want to know the number of
days in that month (February, after all, doesn't have the same number of days
each year), you can calculate that. Suppose the date is in A1. Then
=day(date(year(a1),month(a1)+1,0)) will show the number of days in that month.
--Bruce

"ahmed" wrote:


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

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")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"ahmed" wrote in message
...
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

"bpeltzer" wrote:

Create a table with the month name in column A and the # days in column
B.
Suppose this is on Sheet2. Then =vlookup("June",Sheet2!A:B,2,0) would
return
the cell from column B in the same row where you have June in column A.
Alternately, if you have a particular date and want to know the number of
days in that month (February, after all, doesn't have the same number of
days
each year), you can calculate that. Suppose the date is in A1. Then
=day(date(year(a1),month(a1)+1,0)) will show the number of days in that
month.
--Bruce

"ahmed" wrote:


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