Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to get the fiscal year from a date in Excel and Google Sheets
Topic:Date arithmeticExcel & Google Sheets
=IF(MONTH(A2)>=4,YEAR(A2),YEAR(A2)-1)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter your date in A2.
- 2For a fiscal year starting in April (common in UK, India, and Australia), enter =IF(MONTH(A2)>=4,YEAR(A2),YEAR(A2)-1).
- 3This returns the year in which the fiscal year started: April 2024 through March 2025 all return 2024.
- 4Change the 4 to match your fiscal year start month: 7 for July start, 10 for October start, 1 for January (same as calendar year).
- 5To label as 'FY2024', prefix with text: ="FY"&IF(MONTH(A2)>=4,YEAR(A2),YEAR(A2)-1).
Tips
- For a fiscal year that ends in the following calendar year (e.g., FY2025 = April 2024 to March 2025), some organizations label by the ending year instead. Adjust: ="FY"&IF(MONTH(A2)>=4,YEAR(A2)+1,YEAR(A2)) to get 'FY2025' for April 2024.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
How do I get the fiscal quarter as well?
Combine fiscal month offset with ROUNDUP: =ROUNDUP(MOD(MONTH(A2)-4+12,12)/3+1,0) gives fiscal Q1-Q4 for an April fiscal year start. Pair this with the fiscal year formula for a full FY label.
What if my fiscal year starts in July?
Change the comparison month to 7: =IF(MONTH(A2)>=7,YEAR(A2),YEAR(A2)-1). July 2024 through June 2025 will all return 2024.
More on Date arithmetic
See all →Reference
TODAY / DATEDIF
Work with the current date and measure the gap between two dates.
How-toHow to calculate age from a date of birth
Turn a birth date into an age in years with DATEDIF and TODAY. Works the same in Excel and Google Sheets.
ReferenceDATEDIF
Calculates the difference between two dates in years, months, or days using a unit code string.
How-toHow to calculate days between two dates
Subtract one date from another to get the number of days, or count working days with NETWORKDAYS. Works in both apps.
How-toHow to add months to a date
Shift a date forward or back by a number of months with EDATE — it handles month lengths correctly. Works in both apps.
How-toHow to flag overdue dates
Mark rows whose due date has passed by comparing it to TODAY() with IF. Works the same in Excel and Google Sheets.