formula for specific dates based on another date in worksheet

C

Carol

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?
 
B

Bob Phillips

=A2+60

etc.

--

HTH

Bob Phillips

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

Carol

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?
 
S

SimonCC

If the exit date is in cell A2, quarter end from exit date plus 60 days would
be:
=DATE(YEAR(A2),INT((MONTH(A2)-1)/3)*3+4,60)

-Simon
 
B

Bob Phillips

=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)
 
B

Bob Phillips

The 60 at the end.

--

HTH

Bob Phillips

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