EXCEL DATE

%3CLINGO-SUB%20id%3D%22lingo-sub-2087237%22%20slang%3D%22en-US%22%3EEXCEL%20DATE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2087237%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EHOW%20TO%20CREATE%20EXCEL%20CALCUTIONS%20USING%20MONTHS%3C%2FP%3E%3CP%3ELIKE%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EJanuary%3CBR%20%2F%3EFebruary%3CBR%20%2F%3EMarch%3CBR%20%2F%3EApril%3CBR%20%2F%3EMay%3CBR%20%2F%3EJune%3CBR%20%2F%3EJuly%3CBR%20%2F%3EAugust%3CBR%20%2F%3ESeptember%3CBR%20%2F%3EOctober%3CBR%20%2F%3ENovember%3CBR%20%2F%3EDecember%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3Bany%20one%20help%20me%20the%20formula.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIf%20date%20using%20formula%20know%20range%20%22%26gt%3B%3D%22%20range%22%26lt%3B%3D%22..%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eplease%20help%20me%20only%20using%20month%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2087237%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2087539%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20DATE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2087539%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F931234%22%20target%3D%22_blank%22%3E%40SUDHAKAR-FRONTIER%3C%2FA%3E%26nbsp%3BI'm%20not%20clear%20what%20exactly%20you%20need%20(a%20sample%20sheet%20would%20help)%20but%20here%20is%20an%20example%20I%20show%20how%20you%20could%20do%20comparisons%20using%20only%20the%20text%20of%20the%20month%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mtarler_0-1611334124679.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F248564i0FC9EDBD78F4DB7A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mtarler_0-1611334124679.png%22%20alt%3D%22mtarler_0-1611334124679.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ehere%20is%20the%20formula%20I%20used%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(AND(I2%26gt%3B%3DDATEVALUE(G2%20%26amp%3B%22%201%2C%20%22%26amp%3BYEAR(I2))%2CI2%3CDATEVALUE%3E%3C%2FDATEVALUE%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Ebasically%20I%20converted%20the%20month%20TEXT%20into%20a%20DATEVALUE%20based%20on%20the%20text%2C%20the%20day%20of%20%221%22%20and%20the%20year%20from%20the%20date%20it%20will%20be%20compared%20against.%3C%2FP%3E%3CP%3EThere%20are%20many%20other%20potential%20solutions%20but%20without%20knowing%20more%20about%20your%20application%2Fneeds%20I%20just%20gave%20a%20simple%20one%20that%20is%20easy%20to%20understand%2Fmodify.%26nbsp%3B%20I%20hope%20it%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2089355%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20DATE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089355%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F931234%22%20target%3D%22_blank%22%3E%40SUDHAKAR-FRONTIER%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERather%20than%20converting%20the%20text%20to%20a%20date%20value%20why%20not%20enter%20a%20date%2C%20such%20as%2001%2F01%2F2021%20then%20custom%20format%20the%20cell%20as%20%22mmmm%22%20result%20equaling%20%22January%22.%20As%20dates%20are%20stored%20as%20numbers%2C%20in%20this%20case%2044197%2C%20it%20is%20then%20easy%20enough%20to%20do%20%22%26lt%3B%3D%22%20or%20%22%26gt%3B%3D%22%20calculations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERich%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2089610%22%20slang%3D%22de-DE%22%3ESubject%3A%20EXCEL%20DATE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089610%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F931234%22%20target%3D%22_blank%22%3E%40SUDHAKAR-FRONTIER%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECalendars%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2Fcalendars%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftemplates.office.com%2Fen-us%2Fcalendars%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdditional%20infos%20about%20Date%20and%20Time%20and%20the%20posible%20function%2C%20see%20the%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20you%20continued%20success%20with%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi 

HOW TO CREATE EXCEL CALCUTIONS USING MONTHS

LIKE


January
February
March
April
May
June
July
August
September
October
November
December

 any one help me the formula.

If date using formula know range ">=" range"<="..

please help me only using month

3 Replies

@SUDHAKAR-FRONTIER I'm not clear what exactly you need (a sample sheet would help) but here is an example I show how you could do comparisons using only the text of the month:

mtarler_0-1611334124679.png

here is the formula I used:

=IF(AND(I2>=DATEVALUE(G2 &" 1, "&YEAR(I2)),I2<DATEVALUE(G3&" 1, "&YEAR(I2))),"It is in the month "&G2,"It is NOT in the month "&G2)

basically I converted the month TEXT into a DATEVALUE based on the text, the day of "1" and the year from the date it will be compared against.

There are many other potential solutions but without knowing more about your application/needs I just gave a simple one that is easy to understand/modify.  I hope it helps.

 

@SUDHAKAR-FRONTIER 

Rather than converting the text to a date value why not enter a date, such as 01/01/2021 then custom format the cell as "mmmm" result equaling "January". As dates are stored as numbers, in this case 44197, it is then easy enough to do "<=" or ">=" calculations.

 

Rich

@SUDHAKAR-FRONTIER 

 

Calendars

https://templates.office.com/en-us/calendars

 

Additional Infos about Date and Time and the posible Funktions, see the file.

 

I would be happy to know if I could help.

 

I wish you continued success with Excel

 

Nikolino

I know I don't know anything (Socrates)