R
Rick
Hi,
How can I get the difference in days between 2 dates, less any
Saturdays or Sundays that fall within the period, returned in A3?
e.g.
A1 = Start date of "5-Dec-07"
A2 = Finish date of "28-Dec-07"
A3 = Formula calculates days worked as "17"
Cell A3 would return 17 days, i.e. 23 less the 3 Saturdays and the 3
Sundays that fall within the priod.
Any help would be appreciated, Ricky.
How can I get the difference in days between 2 dates, less any
Saturdays or Sundays that fall within the period, returned in A3?
e.g.
A1 = Start date of "5-Dec-07"
A2 = Finish date of "28-Dec-07"
A3 = Formula calculates days worked as "17"
Cell A3 would return 17 days, i.e. 23 less the 3 Saturdays and the 3
Sundays that fall within the priod.
Any help would be appreciated, Ricky.