View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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)?