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 […]

Find date given day and week

La Th─âng asks: I want to find day if given date and week, for example : if given Tuesday, 32th […]

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 […]