Hi,
I have getting problem to show the fiscal year for following date range;
Date F/Y
17/07/2006 - 16/07/2007 2006/2007
17/07/2007 - 15/07/2008 2007/2008
16/07/2008 - 15/07/2009 2008/2009
16/07/2009 - 16/07/2010 2009/2010
17/07/2010 - 16/07/2011 2010/2011
17/07/2011 - 15/07/2012 2011/2012
16/07/2012 - 15/07/2013 2012/2013
what formula should I type in excel to get F/Y for above date range? Please tell me.
Bookmarks