If current Fiscal Year, check box
I am trying to create a formula that checks a box if the date in the Date Column is this fiscal year - which for us is July - June.
Here is what I have so far which is not giving me an error but also not checking the box for the date which is this FY (4/22/22).
=IF(AND(MONTH([Date]@row) > 6, YEAR([Date]@row) + 1 = "2022"), 1, 0)
Help Article Resources
Check out the Formula Handbook template!