Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number of Week Days only in Date Range function?

Status
Not open for further replies.

cgreene508

Technical User
Jun 30, 2010
1
US
Hi,
I'm new to this forum and to SharePoint 2007.

Is there a formula or function that will count the number of "Week Days" only in a date range? That is: only count the number of Mondays through Fridays, and minus out all Saturdays and Sundays.

BEGIN EXAMPLE: if I have a date range that is seven full weeks, we would need a formula that would return 35 as the number of days in that date range. END EXAMPLE

Thanks,
Chris
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top