sadavies2906
New Member
- Joined
- Feb 5, 2011
- Messages
- 45
Hi
I am trying to calculate the start date of the first operation based on the start date of the second operation. Typically this is always going to be 7 days (5 work days) before. I can do this easily by just deducting 7 from the second operations start date however I have a calendar lookup that checks if a particular day is a holiday which I use on other calculations for networkdays.
Is there an easy way to do this so the first operation is 7 days earlier but also taking into account any holidays identified so if a bank holiday for example it might start 8 days earlier to take into account the holiday
Regards
Stephen
I am trying to calculate the start date of the first operation based on the start date of the second operation. Typically this is always going to be 7 days (5 work days) before. I can do this easily by just deducting 7 from the second operations start date however I have a calendar lookup that checks if a particular day is a holiday which I use on other calculations for networkdays.
Is there an easy way to do this so the first operation is 7 days earlier but also taking into account any holidays identified so if a bank holiday for example it might start 8 days earlier to take into account the holiday
Regards
Stephen