| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to Indicate name of day (Sunday, Monday etc..) based on a Date | Excel Discussion (Misc queries) | |||
| Worksheet name / reference as a formula? | Excel Discussion (Misc queries) | |||
| Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
| formula to calculate a column based on dates in a different colum. | Excel Worksheet Functions | |||
| How do I write a formula to color code based on dates provided or. | Excel Worksheet Functions | |||
Linear Mode
