Create work calendar in Excel - Only working days

If you want to create a calendar in Excel that only includes workdays, you might think that it is a complicated endeavor. However, with the right tips and tricks, you can easily accomplish this process. In this guide, you will learn how to remove Saturdays and Sundays from your calendar and only display the workdays. This will allow you to effectively use your work calendar to improve your office organization.

Key Takeaways

• You can create a calendar in Excel that only shows workdays.
• The function to fill in workdays can save you a lot of time.
• Even after creating the calendar, you can adjust the settings at any time.

Step-by-Step Guide

Creating a Yearly Calendar

Start by creating a basic yearly calendar. Open Excel and enter the start date of your calendar in a cell, for example, January 1, 2018. You can enter the date neatly in cell B1.

Once the date is entered, select the cell and drag it down to expand the calendar in the respective column. This will create a list of all the days you need for your calendar.

Removing Weekends

Now that you have all the days, I want to show you how to easily filter out Saturdays and Sundays. The first thing you need to do is create a new column and name it "Work Calendar." This will help you keep everything organized.

To filter out all weekdays from your list, select the date you just inserted into the new column and drag the small box that allows for auto-filling. When you release the mouse, you will be given an option to select only the workdays. Choose this option to remove Saturdays and Sundays.

You will see the list update to show only the workdays - Monday to Friday. This is how easily you can eliminate all weekends.

Adjusting the Data

After creating your work calendar, you may want to make some adjustments or add data. If you want to add Saturdays and Sundays back into the list, you can use the auto-fill option again. Simply select the column you created and choose "Fill Data."

You can customize the options to switch between different data types. Click on "Start" and select the desired settings under "Fill." Here, you can switch from "Workday" back to "Day" if you want to see all weekdays again.

This gives you the flexibility to tailor and adjust your calendar as needed.

Summary

You have learned how to create a work calendar in Excel that only displays the necessary workdays. With the steps mentioned above, you can quickly and easily filter out Saturdays and Sundays from your planning. Use this technique to further enhance your efficiency at the office.