Excel Formulas

How to Calculate Expiration Date with Excel Formula

Sometimes we need to calculate the expiration date for our final reports to get a reminder before the end of the expiry date. Using Microsoft Excel ...

Convert Time Zone with Daylight Savings in Excel (2 Cases)

If you are searching for a solution or some special tricks to convert time zone to daylight savings in Excel then you have landed in the right place. ...

Add Milliseconds to Time in Excel (with Quick Steps)

This article illustrates how to add milliseconds to time in Excel. The available time formats in Excel are enough for most cases. But assume you are ...

Excel Formula to Compare If a Date is Greater Than Another Date

Microsoft Excel has opened a new era in the field of automation of calculation. You can just apply features and create formulas and Excel will make ...

Conditional Formatting for Dates Older Than Certain Date in Excel

In our Excel spreadsheet, we use dates to track the data according to our desire. Sometimes, we require conditional formatting to highlight those ...

Return Expected Value If Date Is Greater Than Today in Excel

If you are looking for special tricks to know how to change cell value if the date is greater than today in Excel, you've come to the right place. ...

Excel Formula If Date Is Less Than Today (4 Examples)

Let’s say we have a Student-wise Submission Dates list of a certain institution. This dataset contains the First Names, Last Names, and Submission ...

How to Add 30 Minutes to Time in Excel (3 Easy Methods)

We often use time in our worksheets for business purposes, educational purposes, and many others. Sometimes, we need to add or subtract time in the ...

If a Value Lies Between Two Numbers Then Return Result in Excel

Excel is a popular and useful tool for analyzing large sets of data. Now, wouldn’t it be great if we could add decision-making ability to our ...

How to Merge Tables from Different Sheets in Excel (5 Easy Ways)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In Excel, we ...

How to Find Missing Values in Excel (3 Easy Ways)

Let's use the following sample dataset to illustrate the methods for checking missing values. Method 1 - Using Combination of IF and ...

How to Calculate Travel Time Between Two Cities in Excel (2 Ways)

Microsoft Excel may determine the separation between two specific cities or locations on the planet. It is essential to be able to determine the ...

How to Find If Date Is Within 3 Months in Excel (5 Easy Ways)

In this article, we will learn to find if a date is within 3 months in Excel. Sometimes, we need to check if a given date is within the next or last ...

Excel Formula If Date Is Greater Than 2 Years (3 Examples)

While working with Microsoft Excel, sometimes we need to calculate the date which is greater than 2 years for the convenience of our work. ...

How to Create a Search Box in Excel (4 Easy Methods)

While working with a huge set of data in Microsoft Excel, Search box is an important tool to find particular data. A search box makes an Excel ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo