# Date functions

Date functions calculate dates and manipulate date information.

System formats affect the way dates are displayed. See Opening files with different system formats.

This function | Returns |
---|

Date | The calendar date for a month, day, and year. |

Day | A number from 1 to 31, for the day of the month on which a date occurs. |

DayName | Text that is the full name of the weekday for a date. |

DayOfWeek | A number representing the day of the week on which a date occurs. |

DayOfYear | The number of days from the beginning of the year of a date. |

Month | A number from 1 to 12, representing the month of the year in which a date occurs. |

MonthName | The full name of the month for a date. |

WeekOfYear | The number of weeks after January 1 of the year of a date. |

WeekOfYearFiscal | A number from 1 to 53, representing the week containing a date, from a starting day. |

Year | A number representing the year in which a date occurs. |

## Notes

•You can use zero (0) and negative numbers as date function arguments. For example, the following formula returns **5/31/2019**:

`Date(6;0;2019)`

About functions

About formulas

Entering dates with two-digit years