DAYS function

The DAYS function returns the number of days between two dates.

Parts of a DAYS function

DAYS(end_date,start_date)

Part Description

Notes

end_date The end of the date range.  
start_date The start of the date range.  

Sample formulas

DAYS("7/24/1969", "7/16/1969")
DAYS(“2/28/2016”, “2/28/2017”)

Notes

The DAYS function factors in leap days. 

Examples

The below example shows the difference between two days in the same month.  

  A

B

1 Formula Result
2 =DAYS("7/24/1969", "7/16/1969") 8


The below example shows the difference between two dates factoring in a leap day:

  A B
1 Formula Result
2 =DAYS(“2/28/2016”, “2/28/2017”) 366

Related functions

  • DAY: Returns the day of the month that a specific date falls on, in numeric format.
  • DAYS360: Returns the difference between two days based on the 360-day year used in some financial interest calculations.
  • NETWORKDAYS: Returns the number of net working days between two provided days.
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu