If you need to count days in Google Sheets, the fastest method is to subtract one date from another. Sheets stores dates as numbers, so the difference between two date cells gives you the number of days between them right away. Once you know that, you can also calculate date spans, fill date lists, format dates correctly, and sort them in the right order without guesswork.
Count Days Between Two Dates
The simplest answer to how to calculate days in Google Sheets is basic subtraction. Put a start date in one cell and an end date in another, then subtract the start date from the end date. The result is the number of days between them.
Use a subtraction formula
If A2 has the start date and B2 has the end date, enter this in C2:
=B2-A2
This returns the exact number of days between the two dates. If B2 is earlier than A2, the result is a negative number, which is useful when checking date order or deadline problems.
Count days from one date to today
If you want to count how many days have passed since a date, subtract that date from TODAY().
=TODAY()-A2
This is the cleanest way to calculate no of days in Google Sheets for an ongoing task, age, age in days, project duration, or time since a start date.
Count days without time affecting the result
If your cells include timestamps, like 3/10/2026 4:15 PM, the subtraction still works, but the result can include decimals. To force a whole number of days, wrap the formula in INT:
=INT(B2-A2)
This strips out the time portion and leaves only full days.
Use Date Functions for Cleaner Date Math
If you are asking how to calculate dates in Google Sheets, date functions help you build or adjust dates without typing them manually. They are also useful when your source data is split into separate year, month, and day values.
Build a date from separate parts
Use DATE when the year, month, and day are in separate cells. For example, if A2 is year, B2 is month, and C2 is day, enter:
=DATE(A2,B2,C2)
This is the correct way to make dates in Google Sheets from raw parts, and it avoids problems caused by regional date formats.
Add or subtract a number of days
To move a date forward or backward by a fixed number of days, add or subtract the number directly. If A2 contains a date and B2 contains 14, use:
=A2+B2
or
=A2-B2
This is the easiest way to calculate dates in Google Sheets when you want a due date, follow-up date, or scheduled date.
Use date difference with named functions
If you need the difference in months or years instead of days, Sheets offers DATEDIF. For days, the simpler subtraction method is better. For example:
=DATEDIF(A2,B2,”D”)
This returns the number of days between two dates, and it reads clearly when you need to show the unit in the formula itself.
Format Dates So Google Sheets Reads Them Correctly
Many date problems start because Sheets sees your entry as text instead of a date. If you want to format dates in Google Sheets correctly, set the cell format before you enter data, or convert existing text into proper date values.
Set the date format
- Select the cells that contain dates.
- Open the Format menu.
- Choose Number, then Date.
This is the standard way to make date format in Google Sheets when you want month, day, and year displayed consistently.
Convert text into dates
If a date does not work in formulas, it may be stored as text. Use DATEVALUE to convert it. For example, if A2 contains text that looks like a date, enter:
=DATEVALUE(A2)
After conversion, you can subtract, sort, and format it like a real date. This is the direct fix for users asking how to convert dates in Google Sheets.
Make dates display in your preferred style
If you want a specific format, such as 2026-11-15 or 15 Nov 2026, use custom number formatting. Select the cells, then go to Format, Number, Custom date and time. Pick the pattern you want, then apply it. This changes how the date looks without changing the actual value.
Fill Date Series and Make a List of Dates
If you want to fill dates in Google Sheets, use drag fill or a formula. This is the fastest way to make a list of dates in Google Sheets for schedules, logs, calendars, and trackers.
Fill a consecutive date series
- Enter the first date in a cell.
- Enter the next date in the cell below it, or use a formula that adds 1 day.
- Select both cells.
- Drag the fill handle down to extend the pattern.
If the pattern does not continue correctly, Google Sheets is treating the cells as text, so reformat them as dates first.
Use a formula to generate dates down a column
If A2 has the first date, enter this in A3:
=A2+1
Then drag the formula downward. This is the cleanest way to fill date series in Google Sheets when you want a long list without manual typing.
Create a list of dates automatically
To generate a full date list between two endpoints, put the start date in A2 and the end date in B2. In another cell, use a row-based formula like this:
=SEQUENCE(B2-A2+1,1,A2,1)
This creates every date from the start to the end date in order, one per row. It is useful for attendance sheets, availability calendars, and planning templates.
Put Dates in Order and Organize Them
If your dates are mixed up, you need to sort them as actual date values, not text. Once Sheets recognizes the cells as dates, it can put dates in order in Google Sheets with a standard sort.
Sort one date column
- Select the range that includes your date column and any related data.
- Open Data, then choose Sort range.
- Select the date column.
- Choose A to Z for oldest to newest, or Z to A for newest to oldest.
This is the direct answer to how to order dates in Google Sheets when you need chronological order.
Keep rows together when sorting
If your dates belong to names, tasks, or project details, always select the full table before sorting. That keeps each row intact while you make dates in Google Sheets in order. If you sort only the date column, the data in other columns will no longer match.
Fix date order problems caused by text
If sorting gives the wrong result, the dates are probably text. Convert them with DATEVALUE, or re-enter them using a recognized date format. After that, sorting will work correctly and you can organize dates on Google Sheets without manual cleanup.
Common Date Tasks and Quick Answers
Once you know how to do dates in Google Sheets, the same core tools cover most everyday tasks. Subtraction counts days, DATE builds dates, formatting controls display, and sorting keeps everything in order.
How to add dates to Google Sheets
Type a date directly into a cell, such as 11/15/2026 or 15 Nov 2026, depending on your locale and sheet settings. If Sheets recognizes it as a date, it will align the value properly and allow date math. If it stays left-aligned and acts like text, change the cell format to Date.
How to make dates in Google Sheets in order
Enter the first two dates in a series, select both cells, then drag the fill handle downward. Sheets uses the pattern to continue the sequence. This is faster than typing each date one by one and is the standard way to make a list of dates in Google Sheets.
How to calculate days in Google Sheets from a start and end date
Use simple subtraction. That is the most accurate and readable method for most cases. If you need complete days only, wrap the formula in INT. If you need a live count from today, subtract the start date from TODAY().
Frequently Asked Questions
How do I count days in Google Sheets if the cells include time?
Subtract the dates, then wrap the formula in INT to remove the time fraction. For example, =INT(B2-A2) returns full days only. If you need hours or minutes, keep the raw subtraction result and format the cell as a number.
Why does my date not sort correctly in Google Sheets?
Because the cell is stored as text instead of a real date. Convert it with DATEVALUE or re-enter it in a recognized date format, then sort the column again. Real date values sort chronologically, text does not.
What is the easiest way to make a date series in Google Sheets?
Enter the first date, put =A2+1 in the next cell, then drag the formula down. This creates one new date per row and is the simplest method for filling a date series.
How do I make a list of dates between two dates?
Use =SEQUENCE(end-start+1,1,start,1). If A2 has the start date and B2 has the end date, the formula =SEQUENCE(B2-A2+1,1,A2,1) creates every date in between, in order.
How do I change the way dates appear without changing the date itself?
Select the cells and apply a date format from the Format menu, or use custom date formatting. This changes the display style only, not the underlying date value.
Related Posts:
Google Sheets
- How to Remove a Drop-Down in Google Sheets
- How to Merge Cells in Google Sheets
- How to Change Cell Width in Google Sheets
- How to Convert Google Sheets to Excel
- How to Freeze Rows and Columns in Google Sheets
- How to Add Cells and Columns in Google Sheets (SUM)
- How to Make a Graph in Google Sheets
- How to Delete or Remove a Filter View in Google Sheets
- How to Calculate Totals in Google Sheets
- How to Remove Duplicates in Google Sheets
- How to Sort in Google Sheets (A to Z, by Column)
- How to View Hidden Sheets and Rows in Google Sheets