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:

[TABLE="width: 222"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Fiscal Year:[/TD]
[TD="align: right"]10/1/2017[/TD]
[TD="align: right"]9/30/2017[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Date of Writeoff:[/TD]
[TD]Fiscal Year[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]12/1/2018[/TD]
[TD="align: right"]2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]9/28/2017[/TD]
[TD="align: right"]2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]5/4/2014[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]