Jan 22 2021 07:48 AM
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
Jan 22 2021 08:53 AM
@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.
Jan 23 2021 01:26 AM
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
Jan 23 2021 05:01 AM
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)