DATE Function Archives

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

Mar 4, 2023 Excel Basics

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)

Mar 6, 2023 Excel Basics

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

Feb 7, 2023 Advanced Excel

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)

Feb 14, 2023 Excel Functions

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)

Feb 6, 2023 Excel Basics

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)

Feb 7, 2023 Excel Formulas

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)

Feb 6, 2023 Excel Formulas

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)

Mar 22, 2023 Excel Formulas

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)

Feb 12, 2023 Excel Formulas 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 ...

[Fixed] COUNTIF Function with Wildcard Not Working in Excel

Feb 7, 2023 Excel Formulas

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)

Feb 13, 2023 Excel Formulas

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)

Feb 12, 2023 Excel Formulas

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)

Feb 12, 2023 Excel Formulas

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)

Feb 6, 2023 Excel Formulas

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)

Dec 21, 2022 Excel Formulas

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