Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Autofill Weekdays Excluding Weekends in a List of Google Sheet?
When you want to create a list of dates that only include weekdays in Excel, you can do it by default by using the formulas supported by Excel. For example, if we want to create a list of working dates in an office, we can use this process. Leaving out the weekends means ignoring the dates of both Sunday and Saturday in the list.
This tutorial will help you understand how you can autofill weekdays and exclude weekends in a list of Google Sheets. We can complete this process just by using a single formula. We can complete this process directly in Excel by using the autofill handle without needing any formulas, but this is not possible in Google Sheets.
Autofill Weekdays Excluding Weekends in a List of Google Sheet
Here, we will first use the formula to get the first result, then use the auto-fill handle to get all the results. Let's walk through a simple process to see how we can use formulas to autofill weekdays and exclude weekends in a list of Google Sheets.
Step 1
Consider creating a new Excel sheet and clicking on an empty cell from which you want to start the list, entering the formula for the first date from which you want the list to be started, and entering the formula as =A2+IF(WEEKDAY(A2)>5,3,1 in the formula box as we click on enter to get the first result, as shown in the image below.
In the formula, A2 is the address of the first date we have previously entered.
Step 2
Because we can now get a list of only weekdays in Google Sheet by dragging the auto-fill handle, there is no limit to the list, and our final output will look like the image below.
Conclusion
In this tutorial, we used a simple example to demonstrate how you can autofill weekdays and exclude weekends in Excel.
2K+ Views
