DATE Function Archives

Excel Formula to Calculate Number of Days Between Two Dates

Sep 19, 2023 2

Microsoft Excel provides numerous methods to calculate the number of days between two dates using a simple formula. A wide range of functions is ...

Excel Formula to Calculate Number of Days Between Two Dates

[Solved!] Formulas to Compare Dates in Excel Not Working

Mar 4, 2023

In this article, I am going to discuss some possible cases when the formulas to compare dates are not working in Excel and devise some solutions to ...

[Solved!] Formulas to Compare Dates in Excel Not Working

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

May 9, 2023

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

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

Insert Drop Down Calendar in Excel Without Date Picker

May 18, 2023

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

Insert Drop Down Calendar in Excel Without Date Picker

How to Use EOMONTH Function in Excel (10 Ideal Examples)

Feb 14, 2023

Certainly, while working in Excel, we often have dates in the dataset and luckily, Excel has a palette of functions for dealing with dates in the ...

How to Use EOMONTH Function in Excel (10 Ideal Examples)

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

Feb 6, 2023

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 Create an Attendance Roster in Excel (with Easy Steps)

Advanced Use of COUNTIFS Function in Excel (9 Examples)

Feb 7, 2023

The COUNTIFS function is a built-in-in function of Excel. It is more advanced than the COUNTIF function. The COUNTIF function satisfies only one ...

Advanced Use of COUNTIFS Function in Excel (9 Examples)

How to Add 2 Years to a Date in Excel (3 Easy Methods)

Jul 23, 2023 2

Sometimes, it’s essential to include dates in an Excel dataset for ease of use. You may need to add certain years to the date. There are several ...

How to Add 2 Years to a Date in Excel (3 Easy Methods)

[Fixed] COUNTIF Function with Wildcard Not Working in Excel

Feb 7, 2023

The COUNTIF function is used extensively to count values based on criteria. Using wildcards in the criteria makes the formula more dynamic. ...

[Fixed] COUNTIF Function with Wildcard Not Working in Excel

How to Use Nested COUNTIF Function in Excel (6 Suitable Ways)

Sep 21, 2023

Certainly, the heart and soul of an Excel spreadsheet are its functions, and typically, we nest multiple functions to analyze and organize data. ...

How to Use Nested COUNTIF Function in Excel (6 Suitable Ways)

Preparing Bond Amortization Schedule in Excel (with Easy Steps)

Dec 21, 2022

We can perform various finance related tasks in Microsoft Excel very easily. In this article, you will learn about how to prepare a bond amortization ...

Preparing Bond Amortization Schedule in Excel (with Easy Steps)

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

Feb 27, 2023

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

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

How to Create a Schedule in Excel That Updates Automatically

Apr 27, 2023 4

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 Schedule in Excel That Updates Automatically

How to Apply AVERAGEIFS Function Between Two Dates in Excel

Dec 20, 2022

On many occasions in Microsoft Excel, we need to calculate an average of the data between the interval of two dates. For instance, the average cost ...

How to Apply AVERAGEIFS Function Between Two Dates in Excel

How to Create Accrued Interest Calculator in Excel (5 Easy Ways)

Jan 19, 2023

Accrued Interest refers to the payable or receivable interest on a loan or bond at a certain period. Accrued interest doesn’t compound during the ...