tati69angel
New Member
- Joined
- Aug 6, 2010
- Messages
- 5
Hello:
I'm sorry at how silly this question may sound to most of you but I am racking my brain try to figure this out. I am creating a formula that will calculate due dates from a specific start/end date. For example:
If the item was received on August 1, 2010, this task needs to be completed by within ten days. However, the tenth day cannot be a weekend. If if is, then the task should be completed the Friday before.
IE: Initial Assigment received June 24, 2010 (A4)
Acknowledgment letter must be sent within 10 days
=A4+10 results are Sunday July 4, 2010. I need it to say July 2, 2010
By the same token, I also need to be able to subtract to the nearest weekday. For example if the start date of a project is November 1, 2010, certain tasks must be completed 15 days before. But this date cannot be a weekend, it must be the Friday before the weekend day it falls on.
IE: Project Start Date is 11/1/10 (C4)
Letters must be sent 15 days before start date.
=C4-15 results are Sunday October 17, 2010.
I need the results to return Friday, October 15, 2010
Any help would be greatly appreciated.
Thanks again.
I'm sorry at how silly this question may sound to most of you but I am racking my brain try to figure this out. I am creating a formula that will calculate due dates from a specific start/end date. For example:
If the item was received on August 1, 2010, this task needs to be completed by within ten days. However, the tenth day cannot be a weekend. If if is, then the task should be completed the Friday before.
IE: Initial Assigment received June 24, 2010 (A4)
Acknowledgment letter must be sent within 10 days
=A4+10 results are Sunday July 4, 2010. I need it to say July 2, 2010
By the same token, I also need to be able to subtract to the nearest weekday. For example if the start date of a project is November 1, 2010, certain tasks must be completed 15 days before. But this date cannot be a weekend, it must be the Friday before the weekend day it falls on.
IE: Project Start Date is 11/1/10 (C4)
Letters must be sent 15 days before start date.
=C4-15 results are Sunday October 17, 2010.
I need the results to return Friday, October 15, 2010
Any help would be greatly appreciated.
Thanks again.