Welcome!

Formula Help!

Hi there,

Would someone be able to help me with a formula that would be able to calculate the Fiscal Year based on a Finish Date of a project?

FY19 - Feb 2018 - Jan 2019
FY20 - Feb 2019 - Jan 2020
FY21 - Feb 2020 - Jan 2021

Thanks so much!

Find more posts tagged with

Formulas

Comments

Paul Newcome

Try something like this...

="FY" + RIGHT(IF(MONTH([Finish Date]@row = 1, YEAR([Finish Date]@row), YEAR([Finish Date]@row) + 1), 2)

Sign in to join the conversation!

Quick Links

Trending discussions

Need Help With Date Calculation Formula
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
Cell view history
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
Table View Dropdown Sheet Link is Dropping Zeros
I want to use a list of account numbers in one sheet for a dropdown in another sheet using Table View. When I select the sheet and column in the dropdown menu, it shows the correct column but is dropping zeros. I have provided a screenshot of the reference column and then what appears in the drop down. Any ideas?