Fiscal Month Formula
I have been upgraded from excel to Smart Sheet and most of my formulas are able to be translated into Smart Sheet. I am having an issue with taking a date that someone enters and converting into our fiscal. The fiscal months are the same as the calendar month but the month starts on the 22nd of the prior month. So for example Fiscal January 2024 started on 12/22/2023 and will end on 1/21/2024. Below is the formula I use for excel and I am getting a head ache trying to convert it. The output is 2024-01 as an example. Any help would be great. Thank you.
=TEXT(DATE(YEAR([DATE CELL]-21),MONTH([DATE CELL]-21)+1,1),"YYYY-MM")
Help Article Resources
Check out the Formula Handbook template!