The 60 at the end.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Carol" wrote in message
...
So now what part of the formula do I need to change to get 90 and 120
days?

"Bob Phillips" wrote:

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

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Carol" wrote in message
...
Here's a twist to this formula---If a client exits on 4/3/06, I need
to
review their progress at least 60 workdays later but in the next
quarter.
So
how do I calculate quarter end then add the 60 days?

"Bob Phillips" wrote:

=A2+60

etc.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Carol" wrote in message
...
I have an exit date for a client and must do follow up each 60, 90
and
120
dates. How do I write a formula that reads the exit date and
calculates in
a
field for 60, 90 and 120 dates?