Forum Discussion

SUDHAKAR-FRONTIER's avatar
SUDHAKAR-FRONTIER
Brass Contributor
Jan 22, 2021

EXCEL DATE

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 usin...
excel
mtarler's avatar
mtarler
Silver Contributor
Jan 22, 2021

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:

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.

 

Resources