Hi,
I have the following table as attached. I need a formula to calculate the difference in dates based on 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 example as attached, the difference between 6 Sept 2010 and 13 Sept 2010 should be 4 days after excluding Saturdays and Public Holidays.
Appreciate help.
I have a cross post here:
http://www.mrexcel.com/forum/showthr...17#post2454117
Bookmarks