Find the number of days in a month
 

Hi all
I've got to find the number of days in a month based on a date's month
number. thus, I tried the following array formula (which I am pretty sure is
not right):
=IF((MONTH(A14)={1,3,5,7,8,10,12}); 31; IF((MONTH(A14)={4,6,9,11}); 30;
IF((MONTH(A14)=2); 28; "Error"))) but it always gives me the only result:
"ERROR".
Your help will be much appreciated.

Find the number of days in a month
 

Try this

=DAY(DATE(YEAR(A14);MONTH(A14)+1;0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"catrrmg" wrote in message
...
Hi all
I've got to find the number of days in a month based on a date's month
number. thus, I tried the following array formula (which I am pretty sure
is
not right):
=IF((MONTH(A14)={1,3,5,7,8,10,12}); 31; IF((MONTH(A14)={4,6,9,11}); 30;
IF((MONTH(A14)=2); 28; "Error"))) but it always gives me the only result:
"ERROR".
Your help will be much appreciated.

Find the number of days in a month
 

Cheers mate

"Bob Phillips" wrote:

Try this

=DAY(DATE(YEAR(A14);MONTH(A14)+1;0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"catrrmg" wrote in message
...
Hi all
I've got to find the number of days in a month based on a date's month
number. thus, I tried the following array formula (which I am pretty sure
is
not right):
=IF((MONTH(A14)={1,3,5,7,8,10,12}); 31; IF((MONTH(A14)={4,6,9,11}); 30;
IF((MONTH(A14)=2); 28; "Error"))) but it always gives me the only result:
"ERROR".
Your help will be much appreciated.