Get financial year from date

[sharky12345]

I'm trying to find a way to get the financial year from a date - I currently have this;

=IF(A2="","FALSE",DATEDIF(R2,TODAY(),"m")<=12)

I need it to effectively give me the financial year from the date, (the financial year being from 1st April to 31st March).

Is there a way I can do it? I don't mind if it's a formula or through VBA.

 

[Phuoc]

... ...

 

[James006]

Hello,

You can use following :

=YEAR(yourdate)+(MONTH(yourdate)>=4)

Hope this will help

 

[Dave Patton]

Excel 2010
	A	B	C
2	20-Mar-18	FY 2018	FY 2018
3	18-Nov-18	FY 2019	FY 2019
5b

Cell Formulas
Range	Formula
B2	=IF(MONTH(A2)<4,"FY "&YEAR(A2),"FY "&YEAR(A2)+1)
C2	="FY "&YEAR(A2)+(MONTH(A2)>3)

 

[sharky12345]

Thanks guys - both suggestions work.

 

[James006]

You are welcome ...

Glad you could fix your problem ...

 

[Phuoc]

="fy "&year(a1+275)