DATE Function

[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 3 Months to a Date in Excel (4 Easy Methods)

Microsoft Excel provides time management services in a very efficient way. In addition, You can manage your daily, monthly, or yearly schedule easily ...

How to Add 3 Years to a Date in Excel (3 Effective Ways)

When we work with dates in Excel, sometimes we may want to add specific years to a date. It’s quite easy to do in Excel. At the same time, Excel ...

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

How to Convert 13 Digit Timestamp to Date Time in Excel (3 Ways)

An unix timestamp indicates how much time has passed since January 1, 1970 (epoch time). When the timestamp has 11 digits, it displays seconds; when ...

How to Convert Date to Julian Date in Excel (3 Easy Ways)

Usually, users have to perform many tasks in Excel, which includes mentioning dates. These dates can be days, months, or years of a particular time. ...

How to Add and Subtract Dates in Excel (6 Suitable Ways)

While continuing to work with a dataset, sometimes users need to know how to add or subtract dates in Excel. You can simply Add and Subtract Dates in ...

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

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo