Excel Formula - Number of days between 2 dates

Number of days between 2 dates

You can return the number of days between 2 dates by subtracting them.

	A
1	=TODAY() = 02/12/2019
2	=NOW() = 12/2/2019 7:03
3	=A1+7 = 12/9/2019 0:00
4	=A2+14 = 12/16/2019 7:03
5	=DATEDIF(A1,A3,"D") = 7
6	=DATEDIF(A2,A4,"D") = 14
7	="01/08/03"-"28/08/03" = -27
8	=A4-A2 = 14

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

DATEDIFF - 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