Excel DATEVALUE Function - Convert Text to Date

preview_player
Показать описание
In this video, we look at how to use the DATEVALUE function in Excel. This function converts dates stored as text to a date value.

This video converts a variety of date formats demonstrating the usefulness of Excel DATEVALUE function. It also covers a common error people find.

There are a variety of ways to convert text to date in Excel. The DATEVALUE formula is simple and very effective.

*** Online Excel Courses ***

Find more great free tutorials at;

Connect with us!
Рекомендации по теме
Комментарии
Автор

Thank you so much! I have some unusually formatted dates and was able to use this function after some other functions to parse it out.

Legodude
Автор

Thank You for this demo for Function "datevalue"!!!

smakris
Автор

how about if the date is in US format and text, how do u convert to uk date?

tomotobe
Автор

What'll happen if the date value is in mm/dd/yy format???

aravindt
Автор

I want a formula like if we enter yesterday's date..it should show 1 day ago

saypradeep