First Day of Next Quarter
.... or =DATE(YEAR(A1),MONTH(A1)+3-MOD(MONTH(A1)+2,3),1) if you don't want to
bother with the ATP.
--
David Biddulph
Mike H wrote:
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?
|