Seeking a fiscal year formula :-)

Options

I'm looking for a simple formula to generate my fiscal year using the date row.

Fiscal Year Start: Nov 1st

Fiscal Year End: Oct 31


Outcome desired:

If today's date is 8/24/22 - Display FY22 in FY row

If today's date is 11/01/22 - Display FY23 in FY row


Hope that makes sense and thank you in advance!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!