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