Fiscal Year from Date

[jski21]

Good day Mr. Excelites,

Trying to get the correct fiscal year from a date and am a bit stumped. The formula I'm using is =YEAR(E3)+(MONTH(E3)>=$M$3). Snapshot of the sheet is below:

CD Depts. Charts.xlsx
	E									N
1	Jrnl Doc Record Date									Fiscal Year
2	12/27/2017									2018
3	1/29/2018									2018
4	1/29/2018									2018
5	1/18/2018									2018
6	1/25/2018									2018
7	6/14/2017									2018
8	1/11/2017									2017
9	1/24/2018									2018
10	1/25/2017									2017
11	2/8/2017									2017
12	2/22/2017									2017
Master

Cell Formulas
Range	Formula
N2:N12	N2	=YEAR(E2)+(MONTH(E2)>=$M$3)

Cell M3 is not shown in the above but its value is '6.' Fiscal year runs from June 1 - May 31. With that in mind, Cell N3 (and some of the others) needs to read '2017' as the date of 1/29/2018 falls within June 1, 2017 and May 31, 2018. Tried a few iterations but am coming up empty handed (and headed it seems).

Thanks everyone for the direction.


jski

 

[Fluff]

How about

=YEAR(E2)-(MONTH(E2)<$M$3)

 

[jski21]

Yep...every iteration except that one. Thanks Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.