Formulas > =DAYS()

How To Use DAYS() Function in Google Sheets


Returns the number of days between two dates.

Common questions about the DAYS formula:
- How does the DAYS formula work in Google Sheets?
- What is the correct syntax for the DAYS formula?
- Can the DAYS formula handle leap years?
- Can the DAYS formula calculate negative values?

The DAYS formula can be used appropriately to:
- Calculate the number of days between two dates.
- Track the elapsed time between project deadlines.
- Compare the length of different events or time periods.
- Monitor the duration of ongoing activities.

The DAYS formula can be commonly mistyped as:
- Using the wrong date format, e.g., MONTH/DAY/YEAR instead of DAY/MONTH/YEAR.
- Missing/extra commas or parentheses, e.g., DAYS(A1,B2) instead of DAYS(A1,B1).
- Incorrect cell references, e.g., DAYS(A1,B) instead of DAYS(A1,B1).

Common ways the DAYS formula is used inappropriately:
- Using the formula to calculate the difference between non-date values (e.g., numeric or text values).
- Attempting to use the DAYS formula for time-based calculations, instead of date-based calculations.

Common pitfalls when using the DAYS formula:
- Not taking into account the possibility of negative result values (if the end date is earlier than the start date).
- Forgetting that the DAYS formula might not correctly account for Daylight Saving Time changes in some cases.

Common mistakes when using the DAYS formula:
- Using the wrong date format or cell reference, leading to incorrect results.
- Not accounting for leap years or Daylight Saving Time changes in the calculation.
- Confusing the DAYS formula with other date-related formulas (e.g., DATEDIF, DATEVALUE).

Common misconceptions people might have with the DAYS Formula:
- Believing that the DAYS formula can only handle positive numbers, when it can, in fact, calculate the negative difference between two dates.
- Assuming that the DAYS formula takes time-based values into account, which it does not, as it calculates the difference in days without considering the specific hours, minutes, or seconds.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you. 

If you need to replace VLOOKUP, give INDEX/MATCH a try.

How To Actually Use DAYS() in Sheets

DAYS(end_date, start_date)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the DAYS() formula:

Using the DAYS Function in Google Sheets

The DAYS function returns the number of days between two given dates. This function is straightforward and, therefore, easy to learn and use.

Generate a DAYS() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.