DATE function


Excel » Functions » Date and Time » DATE function »

Days between two dates

The DATEDIF function in cell E3 allows you to calculate days between two dates.

How to use the DATE function

The DATE function returns a number that acts as a date in the Excel environment. The image above shows you […]

Calculate date given weekday and week number

This article demonstrates a formula that returns a date based on a week number and a weekday like Sun to […]

Find date range based on a date

This article demonstrates a formula that returns a date range that a date falls under, cell C3 above contains the […]

Identify overlapping date ranges

The formula in cell F6 returns TRUE if the date range on the same row overlaps another date range in […]