If current Fiscal Year, check box

Kendra Hillmer

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)

Thanks!

Antonio Figueroa

Try using this formula

=IF(AND(VALUE(LEFT(Date@row, 2)) > 6, VALUE(RIGHT(Date@row, 2)) = 22), 1, 0)

So if the date is 07/01/22 then it will check the box.

Kendra Hillmer

Thank you - I will try that now!