Arrow left
Back to guides
Google Sheets Formulas

DAYS Function in Google Sheets: Explained

In this article, you will learn how to use the DAYS formula in Google Sheets.

What does the DAYS formula do in Google Sheets?

The DAYS formula gives you the number of days between the two dates given.

How do you use the DAYS function in Google Sheets?

  1. Type “=DAYS” or go to “Insert”“Function” (or directly navigate to the “Functions” icon)  “Date”“DAYS”.
  2. Input the starting and ending dates in two arguments required.
  3. Press the “Enter” key.
How to insert the DAYS function from the menu bar in Google Sheets

The general syntax of the DAYS function is as follows:

=DAYS(end_date, start_date)

End_date: The last date of the period of which length to calculate

Start_date: The first date of the period whose number of days to compute

Note: The DAYS function takes Leap Day into account.

Look at the examples to better understand how the DAYS function works in Google Sheets. Imagine you want to compute the number of days required for projects based on estimated starting and ending dates.

  1. Prepare a project list containing starting and ending dates
  2. Insert the DAYS function in another column
  3. Fill in the arguments by cell reference
How the DAYS function works in Google Sheets with examples

In the next example, let’s make the project list dynamic so that it counts the number of days left to deadlines. By structuring the formula in this way, you have the updated information on the number of days left every time you open the spreadsheet.

  1. Insert a cell containing today’s date
  2. Compute the variance between today’s date and each deadline with the DAYS function for a project
  3. Copy and paste the formula to the other cells for the other projects
How to make the project list dynamic with the TODAY and DAYS functions

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below