Anna Renfroe
Reputation: 1
Query - What is the calc to determine "working days" from a "start date"
I'm asking this for a fellow team member. They are able to calculate the number of days from when the project started, but we need to exclude the weekends (Saturday & Sunday) from the StartDate. Right now, I am getting 8 days, but I know it should be 6 business days (Monday - Friday).
I hope I am explaining this properly.
Thank you.
Upvotes: 0
Views: 40
Answers (0)
Related Questions
- Calculating days to excluding weekends (Monday to Friday) in SQL Server
- Calculate business days skipping holidays and weekends
- Calculate start date with calendar of workdays
- Calculating working hours between two dates - Including weekends
- Getting days since start of week (excluding weekends)
- SQL - Finding working days from days worked
- Calculate Date by number of working days from a certain Startdate
- How do I calculate Workdays except Weekends in SQL query?
- Calculate working days - Monday to Fri in Tsql
- Calculating number of days worked excluding holidays