What is the use of DateValue function?
Converts a date represented by text to a serial number for a date.
Note: To view the serial number as a date following are the steps.
a. Select the cell(which contains serial number)
b. Goto Home tab
c. Goto Number Group
d. Go To Number tab.
e. Select date from the category
f. Select the date format from the Type and then Click Ok.
What is the syntax of DateValue function?
DATEVALUE(date_text)
Where date_text: is text that represents a date.
DATEVALUE Function in Excel – Examples
Reference:
Please refer the below article for more Date & Time Excel functions.
Date & Time Excel Formulas
Please refer the below article for more Excel Functions.
Excel Formulas | Home
Save Up to 85% LIMITED TIME OFFER
A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.
