TODAY() Function stopped working
I have the following formula for determining if an item was used in the last month. Example: between 12/21/2022, and 01/21/2023.
=IF(AND([Date Entered]@row < DATE(YEAR(TODAY()), MONTH(TODAY()), 21), [Date Entered]@row >= DATE(YEAR(TODAY()), MONTH(TODAY()) - 1, 21)), 1, 0)
At some point it has stopped working. It was in a checkbox column and determined if items were automatically sent to finance or not.
Does anyone know why it stopped working, or how to fix it?
Help Article Resources
Check out the Formula Handbook template!