Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leap Year
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leap Year
1)
=IF(O8="February",IF(MOD(S8,400)=0,29,IF(MOD(S8,10 0)=0,0,IF(MOD(S8,4) =0,29,0))),29) 2) =IF(OR(O8={"February","September","April","June"," November"},0,31) HTH Kostis Vezerides On Apr 29, 5:34*pm, 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leap Year
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leap Year
"BadBoy" wrote:
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(or(O8<"February",day(date(S8,3,0))=29),29,0) 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 (or(O8={"February","September","April","June","Nov ember"}),0,31) Note: I assume you mean to put this formula in some other cell, not O8 [sic]. FYI, both formulas can be written without IF(), which can be useful if you are concerned about function nesting. =29*or(O8<"February",day(date(S8,3,0))=29) =31*and(O8<{"February","September","April","June" ,"November"}) Note the change to AND(<) in the latter formula. Alternatively, you can keep the original logic and use the following arcane formulation: =31-31*or(O8={"February","September","April","June","N ovember"}) ----- original message ----- "BadBoy" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leap Year
Wonderful work!
Thank you very much. Your formulas have worked very well. I thank you so much! -Bad "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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leap Year
Wonderful work!
Thank you very much. Your formulas have worked very well. I thank you so much! -Bad "JoeU2004" wrote: "BadBoy" wrote: 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(or(O8<"February",day(date(S8,3,0))=29),29,0) 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 (or(O8={"February","September","April","June","Nov ember"}),0,31) Note: I assume you mean to put this formula in some other cell, not O8 [sic]. FYI, both formulas can be written without IF(), which can be useful if you are concerned about function nesting. =29*or(O8<"February",day(date(S8,3,0))=29) =31*and(O8<{"February","September","April","June" ,"November"}) Note the change to AND(<) in the latter formula. Alternatively, you can keep the original logic and use the following arcane formulation: =31-31*or(O8={"February","September","April","June","N ovember"}) ----- original message ----- "BadBoy" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leap Year
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Leap Year | Excel Discussion (Misc queries) | |||
leap year | Excel Discussion (Misc queries) | |||
Leap Year | Charts and Charting in Excel | |||
How to determine if year is a leap year | Excel Worksheet Functions | |||
is 1900 a Leap Year? | Excel Discussion (Misc queries) |