• Date and Time Functions
  • Date and Time Functions
  • ADDMONTH function
  • ADDYEAR function
  • DAY function
  • DAYSTR function
  • DMY function
  • DTOS function
  • FMTDATESTR function
  • ITOD function
  • LDATE function
  • MKDATE function
  • MONTH function
  • MONTHSTR function
  • PERSTR function
  • PERTOJ function
  • SDATE function
  • SDATETOJ function
  • SYSDATE function
  • SYSTIME function
  • VERDATE function
  • VERSION function
  • VERTIME function
  • YEAR function

DMY Function

The DMY function takes a numeric day, month and year and converts it into the Julian serial number for that date. It is needed for use in financial calculations such as interest, which depend on determining how many days are in a given period.

Syntax

DMY(DD,MM,YY)

Examples

DMY(30,4,07)

Example 1

Using the 1900 date system (the default in Windows), in a cell formatted as numeric, the cell returns the number of days between March 1, 1900 and the date entered.

For this example, 30/4/07 was day 39,141 and that will be the number displayed.

Example 2

In a cell formatted as a date cell, the date is shown formatted either in short form (30/4/07) or long form (April 30, 2007) according to the regional or customized settings chosen in the Date settings.

Example 3

In a cell formatted as alphanumeric, the cell writes out the date in long form formatted according the regional settings used. (e.g., April 30, 2007)

Related Topics

• Date and Time Functions