Forum Discussion
SUDHAKAR-FRONTIER
Jan 22, 2021Brass Contributor
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...
mtarler
Jan 22, 2021Silver Contributor
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.