Category Archives: DATEVALUE

No Thumbnail

Excel, DATEVALUE() Function

The DATEVALUE() function receives as input a text string representing a date. The function returns as output the date value corresponding to the input date text string. Jump To: Syntax Basic Example Why? More Examples – Syntax: =DATEVALUE(Date_Text) Date_Text: A text string representing a date. – Basic Example:

No Thumbnail

Excel, Dates

When working in Excel there are going to be times where you need to specify a date value. There are different methods for specifying a date in Excel. This article briefly explains them and provides links to more detailed explanations. Before explaining the different methods