Forum Discussion
If date is within a table of multiple date ranges return a value also in that table
Example data Start date End date Fiscal year 8/1/2009 7/31/2010 2010 8/1/2010 7/31/2011 2011 8/1/2011 7/31/2012 2012 8/1/2012 7/31/2013 2013 I want to be a...
JBorner I may be a bit late to respond, but I'll still provide an answer.
To determine the fiscal year, you can easily extract the year from the END date using the YEAR function.
Formula = YEAR(End Date)
While there are various methods, simplicity often enhances understanding.
Please consider giving it a 'thumbs up' if the response was helpful for you. (external links removed by moderator)
- This doesn't work. As noted in the example, the year is fiscal and not calendar year so 9/1/2011 is part of year 2012
