WEEKDAY Function

How to Make a Vacation Calendar in Excel (with Detailed Steps)

There are several vacation days throughout the year. Usually, companies make a list of those vacation days and send it to the employees. But we can ...

Insert Drop Down Calendar in Excel Without Date Picker

We need to use the calendar in Excel on daily basis. But for every reason, using a date picker calculator can be quite a hassle. This type of ...

How to Create an Attendance Roster in Excel (with Easy Steps)

In this article, I will show you how to create an attendance roster in Excel. As we know, Excel is a very handy tool for keeping track of employees’ ...

How to Abbreviate Days of the Week in Excel (5 Suitable Ways)

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make ...

How to Create Many to Many Relationship in Excel

When we work with multiple data strings in different worksheets, we often need to merge them. It is mostly required to get an overall view of the ...

How to Extract Month and Day from Date in Excel (6 Methods)

While working on an Excel spreadsheet program, you may need to insert dates to make your work easier. If you want to extract the month and day from ...

How to Use CHOOSE Function to Perform IF Condition in Excel

Looking for ways to use the CHOOSE Function to perform the IF condition in Excel? Then, this is the right place for you. We can use the CHOOSE ...

How to Make an Interactive Calendar in Excel (2 Easy Ways)

For our daily busy life schedule, the calendar is a must needed tool. We have wall calendars in our rooms or pocket calendars on our mobiles or ...

Advanced Uses of CHOOSE Function in Excel (9 Applications)

In this article, we will learn the advanced uses of the CHOOSE function in Excel. The CHOOSE function returns a value from a list using a specified ...

How to Create a Schedule in Excel That Updates Automatically

Creating a schedule is a part and parcel of many of our lives. Creating the schedule automatically will be immensely helpful for many people. If you ...

How to Create a Monthly Calendar in Excel (3 Effective Ways)

Excel is a great tool to automate several calculations and templates. You can create many types of monthly calendars through Excel. If you are ...

How to Make a Calendar in Excel Without Template (2 Examples)

This tutorial will demonstrate how to make a calendar in excel without a template. In our day-to-day life, we all use a deadline for certain work or ...

How to Create a Yearly Calendar in Excel (with Easy Steps)

An Excel calendar could be pretty helpful if you prefer to plan ahead and have a busy schedule. Remembering this, in this article, we’ll go through ...

Formula for Weekly Dates in Excel (5 Examples)

The main focus of this article is to explain formula for weekly Dates in Excel. If you are looking for formulas for weekly dates, then this article ...

Formula for Business Days in Excel (3 Examples)

Not all 7 days of a week are business days! Business days indicate the working days. In an official week, weekends exist too. Not only that, there ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo