DATEVALUE function

This function will convert a date stored as text to a serial number that Excel uses for date values.

Syntax

DATEVALUE(Text)

  • Text (required) –ย This is the date stored as text you would like to convert to a serial number.

Example

In this example we convert a few different text dates to the serial number.

=DATEVALUE("December 31, 2015")

DATEVALUE

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Subscribe

Subscribe for awesome Microsoft Excel videos ๐Ÿ˜ƒ

Related Posts

DAYS function

This function will allow you to find the number of days between two dates....

read more

DATE function

This function will convert a day, month and year to a serial number that Excel...

read more

DAY function

This function will take a date in any format and return the day as an integer...

read more

Comments

0 Comments

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos ๐Ÿ˜ƒ