Formula Help!

Lchicklis

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!

Paul Newcome

Try something like this...

 

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