View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default First Day of Next Quarter

Brian,

Try this

=EOMONTH(TODAY(),MOD(MONTH(TODAY())*2,3))+1

If your using E2003 and get a NAME error then

Tools|Addins and select the analysis toolpak and re-enter the formula

Mike

"Brian" wrote:

Hi, how would one create a cell formula to return the first day of the next
quarter?