DATEVALUE function returns the serial number of a date.

The DATEVALUE function converts a date that is stored as text to a serial number that GoFormz recognizes as a date. For example, the formula =DATEVALUE("1/1/2008") returns 39448, the serial number of the date 1/1/2008. Remember, though, that your GoFormz account date setting may cause the results of a DATEVALUE function to vary from this example.



The DATEVALUE function syntax has the following arguments:

  • value Required. Text that represents a date in a GoFormz date format, or a reference to a cell that contains text that represents a date in a GoFormz date format. For example, "1/30/2008" or "30-Jan-2008" are text strings within quotation marks that represent dates.

In GoFormz, the value argument must represent a date between January 1, 1900 and December 31, 9999.

If the year portion of the value argument is omitted, the DATEVALUE function uses the current year from your device's built-in clock.

The time in value is represented as decimal numbers up to 5 places. A full 24 hour day is equal to the serial number 1. For example, the time 3:00 PM returns .625 as 3:00 PM is 62.5% of the way through the day.


GoFormz stores dates as sequential serial numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900.


Field 1: 11
Field 2: 3
Field 3: 2011

=DATEVALUE("8/22/2011")Serial number of a date entered as text.40777
=DATEVALUE("22-MAY-2011")Serial number of a date entered as text.40685
=DATEVALUE("2011/02/23")Serial number of a date entered as text.40597
=DATEVALUE([Field 1] & "/" & [Field 2] & "/" & [Field 3])Serial number of a date created by combining the values in [Field 1], [Field 2], & [Field 3].40850