EXCEL DATE

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)

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 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.