DATE Function

### How to Autofill Dates in Excel Without Dragging (7 Simple Methods)

In this tutorial, I am going to show you 7 simple methods to autofill dates in excel without dragging. Although you can also do this by dragging, ...

### How to Calculate Remaining Shelf Life Percentage in Excel

In the manufacturing and consumer sector, shelf life is a very popular term. It defines the time period between production and expiration. In a ...

### How to Insert Last Modified Date and Time in Excel Cell

This tutorial will demonstrate how to insert the last modified date and time in an excel cell. When inserting lots of data entries, it is very ...

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

### Excel Formula If One Date is Greater Than Another Date

Microsoft Excel has opened a new era in the field 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 ...

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

### If Cell Contains Date Then Return Value in Excel (5 Examples)

Whilst working with Excel, you may need to check if a cell contains dates and return a value accordingly. Now, wouldnâ€™t it be great to have Excel ...

### Make Credit Card Payoff Calculator with Amortization in Excel

A credit card can be a blessing or a curse. It all depends on a personâ€™s financial knowledge. This article will show you quick steps to create a ...

### How to Create a Bullet Journal in Excel (with Detailed Steps)

This article illustrates how to create a bullet journal in excel. A bullet journal is a system of organizing to-do lists, daily tasks, monthly goals, ...

### Attendance and Overtime Calculation Sheet in Excel

You are in the right place if you have questions about how to keep records of attendance and calculate overtime hours in Excel based on employees' ...

### How to Convert 8 Digit Number to Date in Excel (3 Effective Ways)

Sometimes, you have a column of data that contains dates in the form of numbers, and you need to convert those numbers into dates. If you have a ...

### How to Convert Date to Week Number of Month in Excel (5 Ways)

Looking for ways to know how to convert date to week number of month in Excel? Then, this is the right place for you. Here, you will find 5 different ...

### Excel Gantt Chart with Conditional Formatting (2 Examples)

Gantt Chart is a widely used chart in the managemental branch of any organization. It displays the activities of that institution against the time ...

Advanced Excel Exercises with Solutions PDF