How do I calculate two dates that will include the weekends?
B Bob Phillips May 15, 2008 #2 =A2-A1 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
F Fred Smith May 15, 2008 #3 Don't use Networkdays. Just use normal subtraction, as in: =a2-a1 Regards, Fred.
C Cee C Dec 6, 2010 #4 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.
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.
