Quarter End Date
=DATE(YEAR(A1),(INT((MONTH(A1)-1)/3)+1)*3+CHOOSE(MOD(MONTH(fiscal_start_date
),3)+1,0,1,2),0)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
wrote in message
oups.com...
Thanks very much--this is perfeect. Is there a way to generalize for
any given fiscal year start (ie. use 11 for November as an input)?
|