formula for specific dates based on another date in worksheet
 

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?

formula for specific dates based on another date in worksheet
 

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

formula for specific dates based on another date in worksheet
 

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?

formula for specific dates based on another date in worksheet
 

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


"Carol" wrote:

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?

formula for specific dates based on another date in worksheet
 

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

formula for specific dates based on another date in worksheet
 

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?

formula for specific dates based on another date in worksheet
 

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?