# Solved: Calculate Weekends

Discussion in 'Business Applications' started by andrew1968, Sep 18, 2014.

Not open for further replies.

Joined:
Jul 3, 2014
Messages:
11
Can anyone help me?

I need a way to determine the difference in time between two dates excluding weekends.

For example:

A1: 9/12/2014 8:51
A2: 9/16/2014 14:45

A1 is the start date, A2 is the end date.

The difference between these is 4.25 days, but since it includes a weekend (ideally I'd also include holidays if possible) the ultimate answer I'm looking for is 2.25.

I thought about calculating the total number of week days using NETWORKDAYS, but the problem I run into is that excel includes the entire day even if it's just one hour of that day.

This formula doesn't work because it includes all of 9/12/14 and all of 9/16/14 when I only need it to count a part of those days.

=(A2-A1)-(INT(A2-A1)-NETWORKDAYS(A1,A2))

What would really be great is a NETNONWORKDAYS function (that would calculate weekends and holidays)

Any ideas for me?

2. ### XCubed

Joined:
Feb 21, 2013
Messages:
520
you can try this

=NETWORKDAYS(A1,A2)-MOD(A1,1)-(1-MOD(A2,1))

Joined:
Jul 3, 2014
Messages:
11
Thank you. That basically worked. I just needed to add back in the reminder of the difference between the two dates. Thank you!!!!

As Seen On