Leap Year
"BadBoy" wrote:
"Jacob Skaria" wrote:
=IF(O8={"February","September","April","June","Nov ember"},0,31)
Wonderful work!
Thank you very much. Your formulas have worked very well.
It did?! Did you try anything other than February, e.g. April?
I believe it needs to be:
=IF(OR(O8={"February","September","April","June"," November"}),0,31)
----- original message -----
"BadBoy" wrote in message
...
Wonderful work!
Thank you very much. Your formulas have worked very well.
I thank you so much!
-Bad
"Jacob Skaria" wrote:
Point1:
In which cell are you using your formula. In S8 ?
Or Is the year entered in S8.
Point 2:
Please find the below formula to return 0 or 31.
=IF(O8={"February","September","April","June","Nov ember"},0,31)
If you are looking at returning the days of a month from the "month text"
let me know..
If this post helps click Yes
---------------
Jacob Skaria
"BadBoy" wrote:
Good morning folks,
I have two problems perhaps you may be able to help with.
1) - In the formula below, I wonder if you can help with the following;
If February is in cell O8 and its a leap year, put the number 29 in
cell S8,
if not a leap year, put 0 and if any other month regardless if its a
leap
year or not, put the number 29.
=IF(O8="February",DAY(DATE(S8,3,0)),29)
2) - In the formula below, if any of the months mentioned below are in
cell
O8, place the number 0 in cell O8, otherwise put 31 in cell O8
=If (O8="February","September","April","June","Novembe r",0,31)
Any help you may offer will be much appreciated.
-Bad
|