Archive for 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: Hi Oscar, Need help with a formula Please. I need to figure out the date range of a […]
Identify overlapping date ranges
Table of Contents Find overlapping date ranges Find overlapping date ranges with criterion Find overlapping date ranges Formula in cell […]
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, […]
