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 Let's say the date you want to 'calculate' the fiscal year for is in A1, they this:
=IF(MONTH(A1)>7,YEAR(A1)+1,YEAR(A1))
- This works, but I was hoping to find a way to use the table and not hard code the formula.
JBorner Normally I would agree to use lookup tables, but in this case it's not really necessary. But if you insist, here you go. In its simplest form use LOOKUP as shown in the picture.
