Expressing financial year in excel

[baidya91]

Which formula can I use to express Financial Year 2016-17 with the starting date 01./04/2016 and ending date 31/03/2017? Can anyone help me.To be more specific, it may be expressed it that way: FY From To2016-17 01/04/2016 31/03/20172015-16 01/04/2015 31/03/2016

 

[shg]

Can you give an example of your input and desired output?

 

[baidya91]

If I select FY 2016-17, the column marked with 'From' will be 01/04/2016 and the column marked with 'To' will be 31/03/2017. Similarly, if FY 2015-16 selected, the 'From' Column will be 01/03/2015 and 'To' Column will be 31/03/2016: FY From To 2016-17 1/04/2016 31/03/2017 2015-16 1/04/2015 31/03/2016

 

[shg]

	A​	B​	C​	D​	E​
1​	FY​	From​	To​
2​	2015​	01 Apr 2015​	31 Mar 2016​		B2 and down: =--TEXT(LEFT($A2, 4), "0000-4-1")
3​	2016​	01 Apr 2016​	31 Mar 2017​		C2 and down: =--TEXT(LEFT($A2, 4) + 1, "0000-3-31")
4​	2015-16	01 Apr 2015​	31 Mar 2016​
5​	2016-17	01 Apr 2016​	31 Mar 2017​

 

[baidya91]

Thanks for your help. It works fine.

 

[shg]

You're welcome.