kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 928
- Office Version
- 365
Hi,
I have the following table.
I need to calculate the difference between the dates with the following criteria:
a) Exclude Saturday
b) Exclude Public Holidays
c) If 6 Sept 2010 is the start date and 8 Sept 2010 is end date, then the difference should be 2 days instead of 3 days.
In the above example, the difference between 6 Sept 2010 and 13 Sept 2010 should be 4 days after excluding Saturdays and Public Holidays.
Appreciate help ! Thanks in advance !
I have the following table.
| Excel Workbook | ||||||||
|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | |||
| 35 | Start Date | End Date | Difference | * | * | Public Holidays | ||
| 36 | 06-Sep | 13-Sep | 4 | * | * | 09-Sep | ||
| 37 | * | * | * | * | * | 10-Sep | ||
Sheet1 | ||||||||
I need to calculate the difference between the dates with the following criteria:
a) Exclude Saturday
b) Exclude Public Holidays
c) If 6 Sept 2010 is the start date and 8 Sept 2010 is end date, then the difference should be 2 days instead of 3 days.
In the above example, the difference between 6 Sept 2010 and 13 Sept 2010 should be 4 days after excluding Saturdays and Public Holidays.
Appreciate help ! Thanks in advance !
