DAYS

Calculates the difference, in days, between two date values.

Sample Usage

DAYS(C5,C6)

Syntax

DAYS(date1, date2)

  • date1 - The first date.
  • date2 - The second date.

 

Examples

DAYS(C5,C6) returns the difference in days between two date values in C5 and C6.

 

Notes

  • Ensure that the arguments are cells that contain or evaluate to date values.