MONTH Function Archives

How to Filter Dates by Month and Year in Excel (4 Easy Methods)

Jun 17, 2022 Excel Formulas

In this article, you will find some easy methods to filter dates by month and year in Excel. It is very common to filter dates by month or year as ...

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

Difference Between Two Dates in Months in Excel (4 Suitable Examples)

Jun 8, 2022 Excel Formulas

Sometimes you may need to know how many months have passed between two dates. There are multiple ways to find the difference between two dates in ...

Create a Report That Displays Quarterly Sales in Excel (with Easy Steps)

Jun 2, 2022 Advanced Excel

While working with large Microsoft Excel, sometimes we need to create a report that displays quarterly sales. Creating a report that shows quarterly ...

Split Date and Time Column in Excel (7 Easy Methods)

May 11, 2022 Excel Formulas

If you have a date and time in the same cell and need to separate them into two different columns, you are in right place! In this article, I will ...

How to Calculate Difference Between Two Dates in Days in Excel

Jun 8, 2022 Excel Formulas

We’ll show you 7 quick methods of how to calculate the difference between two dates in days in Excel. To demonstrate our methods, we’ve picked a ...

How to Separate Date in Excel Using Formula (5 Suitable Ways)

May 11, 2022 Excel Formulas

Separating dates from different parts of the text or time is one of the most common uses of Excel. Also extracting day month and year from part of ...

How to Sort Rows by Date in Excel (8 Methods)

May 30, 2022 Excel Books

It’s common to have data with dates and users usually sort rows in Excel by date. Various Excel features such as Sort & Filter. Filter, Custom ...

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 Sort Dates in Excel by Month and Year (4 Easy Methods)

May 30, 2022 Excel Basics

The article will show you some basic methods on how to sort dates in Excel by month and year. It will be pretty simple to understand and apply. In ...

How to Calculate MTD (Month to Date) in Excel (3 Methods)

Jun 26, 2022 Excel Formulas

In this tutorial, we will demonstrate how to calculate MTD (Month to Date) in Excel. Microsoft Excel offers a variety of options for calculating MTD ...

How to Sort Birthdays by Month and Day in Excel (5 Ways)

May 30, 2022 Excel Basics

If you are looking for some of the easiest ways to sort birthdays in Excel by month and day, then this article will be helpful for you. Grouping ...

Excel Interest Only Amortization Schedule with Balloon Payment Calculator

May 29, 2022 Excel for Finance

In this tutorial, we will explain how to calculate an interest-only amortization schedule with a balloon payment calculator in excel. We will develop ...

Get the First Day of the Current Month in Excel (3 Methods)

May 26, 2022 Excel Formulas

Microsoft Excel offers a handful of methods to get the first day of the current month. You can also get the first day of any random month or for the ...

How to Filter Date Range in Excel (5 Easy Methods)

Jun 14, 2022 Advanced Excel

This article will provide some valuable methods on how to filter a range of date(s) in Excel. Suppose you have sales information for one month, but ...