Work with dates
Find the fiscal year of a date
=YEAR(A2)+(MONTH(A2)>=7)How it works in Excel
- YEAR gives the calendar year.
- MONTH(A2)>=7 is true from July onward.
- True counts as 1, so it adds a year.
- Change the 7 to your fiscal year's first month.
The idea in general
A company's year may start partway through the calendar year.
What I assumed
- The date is in A2 and your fiscal year starts in July.
Check the result on your own data before relying on it.