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.
|