NETWORKDAYS including Saturday and Sunday

[Sherry]

How do I calculate two dates that will include the weekends?

 

[Bob Phillips]

=A2-A1

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Fred Smith]

Don't use Networkdays. Just use normal subtraction, as in:

=a2-a1

Regards,
Fred.

 

[Cee C]

what does a2 and a1 represent? the supposed cells where the dates are indicated under?

for example

a2= "11/8/2010 4:00 PM"

and

a1 = "11/2/2010 8:00 AM"

(a2 - a1) = total time between those two dates? Sorry wanted to make sure I was on the right track.