How about
DATEDIFF("day", $StartDate$, $EndDate$) - (2 * DATEDIFF("week", $StartDate$,
$EndDate$))
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Mayfield, Andy L.
Sent: Thursday, October 27, 2011 11:19 AM
To: [email protected]
Subject: Time question
**
I'm trying to count the number of weekdays between two dates.
Is there a way to easily do this? I've used DATEDIFF in the past, but it
counts every day and not just the week days.
Thanks,
Andy L. Mayfield
Alabama Power Company
Protection & Control Technician Sr.
Linc # 10*19140
Cell # 205-288-9140
Office # 205-226-1805
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
