SOLVED

How do I do this?

%3CLINGO-SUB%20id%3D%22lingo-sub-1262443%22%20slang%3D%22en-US%22%3EHow%20do%20I%20do%20this%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262443%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20fairly%20new%20at%20using%20commands%20within%20Excel%20so%20this%20might%20be%20hard%20to%20explain%2C%20but%20I'm%20trying%20to%20use%20a%20command%20where%20if%20today%20is%20in%20a%20certain%20range%20of%20months%20(ie.%20March%20-%20June)%2C%20the%20output%20is%20yes%2C%20and%20if%20today%20is%20not%20in%20that%20certain%20range%20of%20months%20(ie.%20July%20-%20Feb)%2C%20the%20output%20is%20no%20(hopefully%20this%20makes%20sense).%20What%20I%20currently%20have%20is%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EIF%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EAND%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EMONTH%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E3%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EMONTH%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E4%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EMONTH%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E5%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EMONTH%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E6%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22Yes%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22No%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20I'm%20pretty%20sure%20the%20numbers%20I%20inputted%20in%20the%20MONTH%20command%20don't%20actually%20reflect%20the%20months.%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20much%20appreciated.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1262443%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262452%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20do%20this%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262452%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F599770%22%20target%3D%22_blank%22%3E%40moppy1234%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20not%20clear%20what%20is%20your%20source%20data.%20Expression%20like%20MONTH(5)%20returns%20month%20of%20the%205th%20day%20from%20previous%20century%20start%2C%20i.e.%20month%20for%2005%20Jan%201900%2C%20i.e.%201.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20convert%20month%20text%20to%20number%20it's%20like%20%3DMONTH(1%26amp%3B%22May%22)%20which%20returns%205.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262494%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20do%20this%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOh%20I%20see.%20Is%20it%20possible%20for%20the%20source%20data%20to%20be%20in%20real-time%3F%20Or%20do%20I%20have%20to%20create%20a%20set%20of%20dates%20and%20then%20use%20that%20as%20a%20source%20data%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262624%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20do%20this%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262624%22%20slang%3D%22en-US%22%3EThis%20formula%20returns%20%E2%80%9CYes%E2%80%9D%2C%20if%20the%20current%20month%20is%20within%20March%20to%20June%3B%20otherwise%2C%20it%20returns%20%E2%80%9CNo%E2%80%9D.%3CBR%20%2F%3E%3DIF(OR(MONTH(TODAY())%3D%7B3%2C4%2C5%2C6%7D)%2C%3CBR%20%2F%3E%E2%80%9CYes%E2%80%9D%2C%E2%80%9DNo%E2%80%9D)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262672%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20do%20this%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262672%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262912%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20do%20this%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262912%22%20slang%3D%22en-US%22%3EYou%E2%80%99re%20very%20much%20welcome!%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

 

I'm fairly new at using commands within Excel so this might be hard to explain, but I'm trying to use a command where if today is in a certain range of months (ie. March - June), the output is yes, and if today is not in that certain range of months (ie. July - Feb), the output is no (hopefully this makes sense). What I currently have is:

 

=IF(AND(MONTH(3),(MONTH(4)),(MONTH(5)),(MONTH(6))),"Yes","No")

 

but I'm pretty sure the numbers I inputted in the MONTH command don't actually reflect the months.

Any help would be much appreciated. Thanks!

5 Replies
Highlighted

@moppy1234 

It's not clear what is your source data. Expression like MONTH(5) returns month of the 5th day from previous century start, i.e. month for 05 Jan 1900, i.e. 1.

 

If convert month text to number it's like =MONTH(1&"May") which returns 5.

Highlighted

@Sergei Baklan 

 

Oh I see. Is it possible for the source data to be in real-time? Or do I have to create a set of dates and then use that as a source data?

 

Highlighted
Best Response confirmed by moppy1234 (New Contributor)
Solution
This formula returns “Yes”, if the current month is within March to June; otherwise, it returns “No”.
=IF(OR(MONTH(TODAY())={3,4,5,6}),
“Yes”,”No”)
Highlighted

@Twifoo 

 

Thank you so much!!

Highlighted
You’re very much welcome!