Date Data Type

  1. <Data data type>
  2. A date is stored as a number equal to the number of days between it and 1st January 1900 at 00:00:00. Applying the VALUE function to a date yields that number. For example, Excel’s numeric representation of 13th February 2023 is 44970.