WEEKDAY Function

How to Use Ageing Formula in Excel Excluding Weekends (4 Easy Ways)

In Excel, we often need to calculate the age or duration of different products. We also need to know the time period excluded the weekends from it. ...

How to Create Leave Tracker in Excel (Download Free Template)

Leave tracker is a widely used task for the human resource department to track every people for their vacation and working days. Almost every ...

How to Display Day of Week from Date in Excel (8 Ways)

When you are working with to-do lists or daily reports, it is inevitable to display the day of the week from the date in Excel. For any day-specific ...

How to Insert Date in Excel Formula (8 Ways)

Excel can store date values as a different category of its own. Dates starting from 1st January 1990 follows this pattern. You can write dates ...

How to Convert Date to Day of Week in Excel (8 Methods)

02/04/2022 represents a date, it does not provide any information of weekdays. But it is equally necessary to know the day of the week. In this ...

How to Convert Date to Day in Excel (7 Quick Ways)

In our day to day life, it is a must that we have to know the day of a certain date. We can easily convert date to day in Excel. For more ...

How to Get First Day of Month from Month Name in Excel (3 Ways)

During our work with Excel, sometimes we need to know the first day of the given month or date. But there is no direct function or formula in Excel ...

Last Business Day of the Month in Excel (9 Examples)

This article illustrates how to find the last business day of a month in excel. It also shows how to find the last business day/workday in any year. ...

How to Calculate Working Days between Two Dates in Excel (4 Methods)

In this tutorial, we will explain how to use different functions to calculate working days between two dates in excel. Sometimes, it becomes very ...

How to Calculate Turnaround Time in Excel Excluding Weekends (3 Ways)

Excel is undoubtedly one of the most useful tools. We can use Excel to do myriads of things. For example, we often need to calculate the turnaround ...

How to Convert Week Number to Date in Excel (2 Suitable Methods)

In Microsoft Excel, working with week and date is one of the crucial tasks. You will find yourself in a lot of situations where you will have to find ...

How to Sort Excel Sheet by Date (8 Methods)

While working with dates, months, or years in Excel you might need to sort the rows of the worksheet in chronological order based on this ...

How to Use the VBA Weekday Function (2 Suitable Examples)

The Weekday function is one of the most important and widely used functions of VBA. In this article, I’ll show you how you can use the VBA Weekday ...

VBA Date Function (12 Uses of Macros with Examples)

In Microsoft Visual Basic Application, date functions or any date-related concepts are essential to perform various operations in your dataset. You ...

Advanced Filter with Criteria Range in Excel (18 Applications)

In Microsoft Excel, the Advanced Filter option is helpful when looking for data that meets two or more criteria. In this article, we will discuss ...

ExcelDemy
Logo