FormuladrillDATEVALUE practice
DATEVALUE converts a date written as text into a real date serial number. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.
Syntax
DATEVALUE(date_text)
What people get wrong
It is the usual fix for dates that arrive as text from an export and refuse to sort or subtract.
Excel exercise that use DATEVALUE
- Days late from text datesLevel 6Pro
Practice DATEVALUE now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free