# 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 in 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 the hour, minute and 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 | (2010) 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 TopPrevNext