Formula to pull the Fiscal Year from a Launch date

CF19

Hello!

I'm looking to pull the Fiscal Year in a cell based on the launch date in a different cell. Our FY starts on 04/01 of the current and ends on 03/31 of the following year. I need the formula to determine if the FY is the current year, the prior year, or the next year based on the launch date.

For example, 04/25/2024 should populate 2025, 02/14/2024 should populate 2024, and 01/18/2025 should populate 2026.

Currently, in the sheet, I have it as a drop-down list for selection.

Paul Newcome

Wouldn't 1/18/2025 be in FY25 not FY26?

CF19

correct sorry it's a typo for 2026

Paul Newcome

In that case you can use this:

=YEAR([Date Column Name]@row) + IF([date Column Name]@row >= DATE(YEAR([Date Column Name]@row), 4, 1), 1, 0)