Calculate date difference exclude Wkend
Try
=NETWORKDAYS(A1,B1)
Mike
"Cam" wrote:
Hello,
What formula to use to calculate number of days between two different dates
excluding weekend and holiday? THanks
Example:
Start End #days
2/5/08 3/9/08 23
2/8/08 3/9/08 20
2/14/08 3/9/08 16
2/29/08 3/9/08 5
3/3/08 3/9/08 4
2/26/08 3/9/08 8
|