Friday, July 10, 2020
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.