Monday, January 25, 2021
Home Tags Date

# Tag: Date

### Calculate Number of Days in another Date Range

A custom function has been developed to calculate the Number of Days that one Date Range is within another. This can be very useful when calculating the overlapping periods.

### Text not Converting to Date

For this problem we received a copy of the workbook. We then used a formula to convert the original birth date text into a "DateValue" and finally format those cells as dates to create a column with the actual Birth Dates.

### How to use the DateAdd function

To solve this problem we will use one of Excel's built-in functions DateAdd. This function provides the ability to Add and Subtract values from a given date. In this request we need to Add 4 years and 1 day to the date in a particular cell. So lets say we start with a spreadsheet that has the following dates that need to have 4 years and 1 day added to them.

### Search for earliest date in Excel list using vLookup

The solution to this problem can be approached in a number of ways. In this post we will describe and method that uses VLOOKUP a built-in Excel function to derive the result.

### How to use Day, Month and Year Functions

In many cases when working with Excel the we use dates to calculate formulas or display a report. The ability to use the built-in Excel functions that relate to dates and to extend them is a fundamental skill in Excel. This post is the first in a series that will describe the basic use of key functions in Excel for beginners.