WEEKDAY Function Archives

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

Jun 26, 2022 Excel Formulas

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)

Jun 22, 2022 Excel Basics

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)

May 31, 2022 Excel Basics

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)

May 25, 2022 Excel Basics

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)

May 26, 2022 Excel Formulas

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)

May 26, 2022 Excel Formulas

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)

May 26, 2022 Excel Formulas

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)

May 26, 2022 Excel Formulas

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)

May 25, 2022 Excel Formulas

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)

May 25, 2022 Excel Formulas

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)

May 25, 2022 Excel Basics

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)

May 23, 2022 Excel Basics

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)

May 23, 2022 Macros & Excel VBA

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)

May 23, 2022 Macros & Excel VBA

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)

May 19, 2022 Advanced Excel

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 ...