Date & Time Functions
| DATE | The date as a date serial number given a year, month, day. |
| DATEDIF | (Compatibility) The number of days, months or years between two dates. |
| DATEVALUE | The date serial number given a date in text format. |
| DAY | The day as an integer given a date serial number. |
| DAYS | The number of days between two dates. |
| DAYS360 | The number of days between two dates, based on 30 day months. |
| EDATE | The date serial number that is a certain number of months before or after a date. |
| EOMONTH | The date serial number of the last day of a month before or after a date. |
| HOUR | The hour as an integer given a date serial number. |
| ISOWEEKNUM | The number of the ISO week of the year for a given date. |
| MINUTE | The minute as an integer given a date serial number. |
| MONTH | The month as an integer given a date serial number. |
| NETWORKDAYS | (NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays. |
| NETWORKDAYS.INTL | The total number of working days between two dates excluding weekends and holidays. |
| NOW | The date serial number of the current system date and time. |
| SECOND | The number of seconds as an integer given a date serial number. |
| TIME | The time as a decimal given an hour, minute, second. |
| TIMEVALUE | The time as a decimal given a time in text format. |
| TODAY | The date serial number representing today's date. |
| WEEKDAY | The day of the week for a given date. |
| WEEKNUM | The week number in the year for a given date. |
| WORKDAY | (WORKDAY.INTL) The date serial number that is a given number of working days before or after a date. |
| WORKDAY.INTL | The date serial number that is a given number of working days before or after a date. |
| YEAR | The year as an integer given a date serial number. |
| YEARFRAC | The number of years as a decimal between two dates. |
| DATE The date as a date serial number given a year, month, day. |
| DATEDIF (Compatibility) The number of days, months or years between two dates. |
| DATEVALUE The date serial number given a date in text format. |
| DAY The day as an integer given a date serial number. |
| DAYS The number of days between two dates. |
| DAYS360 The number of days between two dates, based on 30 day months. |
| EDATE The date serial number that is a certain number of months before or after a date. |
| EOMONTH The date serial number of the last day of a month before or after a date. |
| HOUR The hour as an integer given a date serial number. |
| ISOWEEKNUM The number of the ISO week of the year for a given date. |
| MINUTE The minute as an integer given a date serial number. |
| MONTH The month as an integer given a date serial number. |
| NETWORKDAYS (NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays. |
| NETWORKDAYS.INTL The total number of working days between two dates excluding weekends and holidays. |
| NOW The date serial number of the current system date and time. |
| SECOND The number of seconds as an integer given a date serial number. |
| TIME The time as a decimal given an hour, minute, second. |
| TIMEVALUE The time as a decimal given a time in text format. |
| TODAY The date serial number representing today's date. |
| WEEKDAY The day of the week for a given date. |
| WEEKNUM The week number in the year for a given date. |
| WORKDAY (WORKDAY.INTL) The date serial number that is a given number of working days before or after a date. |
| WORKDAY.INTL The date serial number that is a given number of working days before or after a date. |
| YEAR The year as an integer given a date serial number. |
| YEARFRAC The number of years as a decimal between two dates. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top