Applications

Create a valid date from year, month, and day

Description

=DATE(year, month, day)

Parameters

  • year – year to use when creating the date
  • month – month to use when creating the date
  • day – day to use when creating the date

Examples

Create date for August 8, 1982

=DATE(1982, 08, 21)

Create date for October 10, 2016

=DATE(2016, 10, 10)

Create date for April 21, 2000

=DATE(2000, 04, 21)

Create date for May 5, 1983

=DATE(1983, 05, 05)

Screen shot 2016 10 03 at 8.29.36 am