Formula to pull the Fiscal Year from a Launch date

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.

Find more posts tagged with

Formulas

Support

Automations

Project Management

Multi-year projects

Accepted answers

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.