Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
What I would like to be able to do in MS Excel (2002) is this and Im not
sure if its possible. How would I take a date field in Excel and decrease that date by three BUSINESS days? Im filling in the blanks on a large roll-out schedule and would rather not if possible manually calculate several hundred dates. Example: The first final date of completion for the project would be Monday 1/17/2005. This date appears in cell C2. I need to show on a schedule that three business days before there will be an installation visit. The result would be Wednesday 1/12/04. This would appear in cell B2. Is there a valid expression for =C2 €“ (3 business day?) |
#2
![]() |
|||
|
|||
![]()
Hi
=WORKDAY(C2,-3) Note: The Analysis Toolpak Addin must be installed for this -- Regards Frank Kabel Frankfurt, Germany "CNGracin" schrieb im Newsbeitrag ... What I would like to be able to do in MS Excel (2002) is this and Im not sure if its possible. How would I take a date field in Excel and decrease that date by three BUSINESS days? Im filling in the blanks on a large roll-out schedule and would rather not if possible manually calculate several hundred dates. Example: The first final date of completion for the project would be Monday 1/17/2005. This date appears in cell C2. I need to show on a schedule that three business days before there will be an installation visit. The result would be Wednesday 1/12/04. This would appear in cell B2. Is there a valid expression for =C2 €“ (3 business day?) |
#3
![]() |
|||
|
|||
![]()
Thank you for the quick response... but that returned a invalid name error.
"Frank Kabel" wrote: Hi =WORKDAY(C2,-3) Note: The Analysis Toolpak Addin must be installed for this -- Regards Frank Kabel Frankfurt, Germany "CNGracin" schrieb im Newsbeitrag ... What I would like to be able to do in MS Excel (2002) is this and I€„¢m not sure if it€„¢s possible. How would I take a date field in Excel and decrease that date by three BUSINESS days? I€„¢m filling in the blanks on a large roll-out schedule and would rather not if possible manually calculate several hundred dates. Example: The first final date of completion for the project would be Monday 1/17/2005. This date appears in cell C2. I need to show on a schedule that three business days before there will be an installation visit. The result would be Wednesday 1/12/04. This would appear in cell B2. Is there a valid expression for =C2 €€œ (3 business day?) |
#4
![]() |
|||
|
|||
![]()
Hi
as stated: You have to install the Analysis Toolpak Addin (goto 'Tools- Addins' and tick this addin) -- Regards Frank Kabel Frankfurt, Germany "CNGracin" schrieb im Newsbeitrag ... Thank you for the quick response... but that returned a invalid name error. "Frank Kabel" wrote: Hi =WORKDAY(C2,-3) Note: The Analysis Toolpak Addin must be installed for this -- Regards Frank Kabel Frankfurt, Germany "CNGracin" schrieb im Newsbeitrag ... What I would like to be able to do in MS Excel (2002) is this and I€„¢m not sure if it€„¢s possible. How would I take a date field in Excel and decrease that date by three BUSINESS days? I€„¢m filling in the blanks on a large roll-out schedule and would rather not if possible manually calculate several hundred dates. Example: The first final date of completion for the project would be Monday 1/17/2005. This date appears in cell C2. I need to show on a schedule that three business days before there will be an installation visit. The result would be Wednesday 1/12/04. This would appear in cell B2. Is there a valid expression for =C2 €€œ (3 business day?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |