How about DATEDIFF("day", $StartDate$, $EndDate$) - (2 * DATEDIFF("week", $StartDate$, $EndDate$))
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 11:19 AM To: arslist@ARSLIST.ORG 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"