DATEVALUE

Formulas / DATEVALUE
Convert text dates to valid Sourcetable dates.
=DATEVALUE(date_text)
  • date_text - required, text value

Examples

    The DATEVALUE function can be used to convert a date from its text form to a number. For example, =DATEVALUE("8/22/2011") returns 40777. This is because Sourcetable stores dates as numbers, and 8/22/2011 is the 40777th day since January 1, 1900.

    The DATEVALUE function is not limited to a specific date format. It can also be used with dates entered in different formats, such as =DATEVALUE("22-MAY-2011"), which returns 40685.

    The DATEVALUE function can also take dates in different formats, such as =DATEVALUE("2011/02/23"), which returns 40597.

    The DATEVALUE function can be used with dates entered in shorthand formats. For example, =DATEVALUE("5-JUL") returns 39634.

    The DATEVALUE function can also be used with multiple cells in a formula. For example, =DATEVALUE(A2 & "/" & A3 & "/" & A4) returns 40850 by using the values in the cells A2, A3, and A4.


Summary

The DATEVALUE function is a useful tool for working with dates in text formats as it can filter, sort, and format them. It is especially helpful in converting dates stored in text to serial numbers.

  • The DATEVALUE function converts a date represented in text into a Sourcetable date and returns a serial number in the Sourcetable date system.
  • The date returned by DATEVALUE is a valid Sourcetable date, which is more useful than text dates.
  • The DATEVALUE function takes only one argument, and throws a #VALUE! error if the date_text does not include a date formatted as text.

Frequently Asked Questions

What is the DATEVALUE Function?
The DATEVALUE function is a function in Sourcetable that converts a date stored as text to a serial number. It is useful for filtering, sorting, and formatting dates as dates.
What are the benefits of using the DATEVALUE Function?
The DATEVALUE function provides several benefits:
  • Filtering dates - the DATEVALUE function allows you to filter dates quickly and easily.
  • Sorting dates - the DATEVALUE function is useful for sorting dates in ascending or descending order.
  • Formatting dates - the DATEVALUE function is useful for formatting dates as dates.
What is the syntax for the DATEVALUE Function?
The syntax for the DATEVALUE function is as follows: DATEVALUE(date_text)
Can I use the DATEVALUE Function with other functions?
Yes, the DATEVALUE function can be used with other functions, such as the AVERAGE, MAX, and MIN functions.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV