Can anyone help me with this?
I need to automatically record the fiscal month of a product based on its Offline Date, which indicates the month it is due.
Our budget years are from October
=IF(MONTH([Offline Date]@row)=> 10, "Fiscal Year " & (YEAR([Offline Date]@row) + 1), "Fiscal Year " & YEAR([Offline Date]@row))
This formula does not work
Help Article Resources
Check out the Formula Handbook template!