See if a date is with a defined date range
I'm trying to create a formula to see if a date with in a date column is within a defined range. It's partly working but the outcome seems to ignore years (returning a result if days/months match) and it dislikes December all together returning nothing.
The formula is - =IF(AND($[Column18]@row >= [Sep 2023]$2, $[Column18]@row < [Oct 2023]$2), "1", "")
Screenshots attached for reference.
Any help would be appraised, thanks
Help Article Resources
Check out the Formula Handbook template!