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

Elizabeth asks: I need to figure out the date range of a cell. So if cell "E2" has a date […]

Identify overlapping date ranges

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