software

Can anyone tell me how to do a lookup of a fiscal year with a given date?


It depends when your fiscal year begins. If the 2006 fiscal year began
on June 1st 2005 then your fiscal year is effectively running 7 months
ahead of the actual year so

=YEAR(A1) (MONTH(A1)gt;5)

will give your the fiscal year when A1 contains your date, e.g.
9/9/2005 gives 2006--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=508590Thank you so very much!!!

quot;daddylonglegsquot; wrote:

gt;
gt; It depends when your fiscal year begins. If the 2006 fiscal year began
gt; on June 1st 2005 then your fiscal year is effectively running 7 months
gt; ahead of the actual year so
gt;
gt; =YEAR(A1) (MONTH(A1)gt;5)
gt;
gt; will give your the fiscal year when A1 contains your date, e.g.
gt; 9/9/2005 gives 2006
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=508590
gt;
gt;