Skip to main content
Windward

DATEVALUE Function

Overview

The DATEVALUE function returns the Serial number of the given date defined by the given year, month and day, using the 1900 date system.

 

 

For example

=datevalue(2011, 8, 22) returns 40777

Syntax

DATEVALUE(year,month,day)
  • ​year - Required. The year for the specific date.
  • month - Required. The month for the specific date.
  • day - Required. The day for the specific date.

 

  • Was this article helpful?