Formula to Calculate FY

[BrittKnee]

I have played around with a few formulas, but have been fairly unsuccessful to get a formula to calculate fiscal year on multiple dates. Does anyone here have one that has worked well?


Thanks.

 

[uknowwhoibe]

I don't know if I can help you but I feel like your question isn't worded in a concise manner. What do you want to do with the FY date range?

 

[BrittKnee]

I work with multiple clients who have varying fiscal year ends. I help prepare financial statements to where I would need to calculate the fiscal year to be sure the data is falling into the year in review. Rather than filtering to each date range, I was wondering if there was a formula that could populate this field. Below not an exact replica, but an example to illustrate what I am trying to do:

	Fiscal Year:	10/1/2017	9/30/2017
	Date of Writeoff:	Fiscal Year
	12/1/2018	2019
	9/28/2017	2017
	5/4/2014	2014

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>