DATE Function

Excel Formula to Calculate Number of Days Between Two Dates

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

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

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

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 Use EOMONTH Function in Excel (10 Ideal Examples)

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

Advanced Use of COUNTIFS Function in Excel (9 Examples)

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

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

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

[Fixed] COUNTIF Function with Wildcard Not Working in Excel

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

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

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

Preparing Bond Amortization Schedule in Excel (with Easy Steps)

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

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

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 Apply AVERAGEIFS Function Between Two Dates in Excel

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 Create Accrued Interest Calculator in Excel (5 Easy Ways)

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo