Number of days between 2 dates
You can return the number of days between 2 dates by subtracting them.
|
Built-in Functions
TODAY - The serial number representing today's date.
NOW - The serial number of the current system date and time.
DATEDIF - (Compatibility) The number of units between two dates.
User Defined Function
DATEUNITS - Returns the number of units between two dates.
Related Formulas
Number of days between 2 dates excluding weekends
Number of mondays between 2 dates
Number of days in a particular month
Number of days in a particular year
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top