# 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 | (2013) 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 | (2013) 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. |

DATEThe date as a date serial number given a year, month, day. |

DATEDIF(Compatibility) The number of days, months or years between two dates. |

DATEVALUEThe date serial number given a date in text format. |

DAYThe day as an integer given a date serial number. |

DAYS(2013) The number of days between two dates. |

DAYS360The number of days between two dates, based on 30 day months. |

EDATEThe date serial number that is a certain number of months before or after a date. |

EOMONTHThe date serial number of the last day of a month before or after a date. |

HOURThe hour as an integer given a date serial number. |

ISOWEEKNUM(2013) The number of the ISO week of the year for a given date. |

MINUTEThe minute as an integer given a date serial number. |

MONTHThe 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.INTLThe total number of working days between two dates excluding weekends and holidays. |

NOWThe date serial number of the current system date and time. |

SECONDThe number of seconds as an integer given a date serial number. |

TIMEThe time as a decimal given an hour, minute, second. |

TIMEVALUEThe time as a decimal given a time in text format. |

TODAYThe date serial number representing today's date. |

WEEKDAYThe day of the week for a given date. |

WEEKNUMThe 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.INTLThe date serial number that is a given number of working days before or after a date. |

YEARThe year as an integer given a date serial number. |

YEARFRACThe number of years as a decimal between two dates. |

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top