View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default End of the 4 quarters

=DATE(YEAR(TODAY()),(INT((MONTH(TODAY())-1)/3)+1)*3+1,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"ben simpson" wrote in message
...
Is there a formula that can match the end of the 4 quarters (March31,June
30,September30, and December 31) to todays date so I can initialize a

report
that is due? I'd like to have the number 5 placed in a cell to remind me.
Thank you for your help.