DATE function
Excel » Functions » Date and Time » DATE function »
DATEVALUE function not working
The DATEVALUE function returns an Excel date value (serial number) based on a date stored as text. However, it must […]
The DATEDIF function in cell E3 allows you to calculate days between two dates.
The DATE function returns a number that acts as a date in the Excel environment. The image above shows you […]
La Thăng asks: I want to find day if given date and week, for example : if given Tuesday, 32th […]
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 […]
Find latest date based on a condition
Table of contents Lookup a value and find max date How to enter an array formula Explaining array formula Download […]
Calculate last date of a given month
The formula in cell C3 calculates the last date for the given month and year in cell B3. =DATE(YEAR(B3), MONTH(B3)+1, […]
Welcome! I am 