Formulas to calculate the number of weekdays, Saturdays, and Sundays between two dates
I have three columns: Weekdays, Saturdays, and Sundays.
I need to calculate the quantity of each of these three types of days based on start and end dates. The NETWEEKDAY and NETWEEKDAYS functions do not work in this case because the start and end dates should be included in the count.
Example: Start date of 8/22/2021 and end date of 8/28/21 should return a value of "5" in the Weekdays column, "1" in the Saturdays column, and "1" in the Sundays column.
Answers
-
Hi @Jennacorso
Hope you are fine, please try the following formula ( those formula need to add if statement formula if the start and end date are in the same week for example the start date was on Thursday and end date Was on Monday )
Weekdays =IFERROR(NETWORKDAYS([Start date]@row, [end date]@row), "")
Saturdays =IFERROR(ROUNDDOWN(Weekdays@row / 5), "")
Sundays =IFERROR(ROUNDDOWN(Weekdays@row / 5), "")
the following screenshot shows the result:
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Bassam Khalil, unfortunately, those formulas do not work. Here are the results from my sheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!