Quarter End Date
=DATE(YEAR(A1),(INT((MONTH(A1)+1)/3)+1)*3-1,0)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
wrote in message
ups.com...
What is a formula that can be used to find the nearest quarter end,
when the fiscal year has a non-standard start date (ie. November fiscal
year, current date is 2/28/2005, quarter end should be 4/30/05)?
|