How to google sheets add days to date: Step-by-step Guide
Learn practical methods to add days to a date in Google Sheets. Master simple arithmetic, work with business days, handle text dates, and apply advanced variations like months and years for real-world scheduling.
To add days to a date in Google Sheets, simply add a number of days to the date cell with a formula like =A2 + B2 or =DATEVALUE(A2) + 7. Make sure the result is formatted as a date, not a number. You can subtract days with negative values, and drag to fill across rows. If dates are text, convert with DATEVALUE first.
Why mastering google sheets add days to date
Dates drive schedules, deadlines, and reminders in spreadsheets. When you need to plan upcoming due dates, build a rolling timeline, or generate a sequence of target dates, learning how to google sheets add days to date saves time and reduces errors. With a single date, you can project weeks, work calendars, or project milestones by adding a numeric offset. This skill scales from student homework trackers to team project dashboards, making it a foundational tool in any Google Sheets toolkit.
In practice, you’ll often start with one date in a cell (for example, cell A2) and then specify how many days to add in another cell (B2). The result will be a new date that you can format and copy downward. The same approach also works in more complex dashboards, where dates connect to statuses, reminders, and automatic alerts. The core idea is simple arithmetic on date values, which Google Sheets handles as serial numbers behind the scenes.
Core concepts: dates, serial numbers, and formatting
Google Sheets stores dates as serial numbers, where each whole number represents a day relative to a baseline (December 30, 1899). This makes arithmetic straightforward: adding 1 to a date moves you one day forward, subtracting moves you backward. To ensure human readability, always format the result as a date. If a date is displayed as a number, select the cell, open Format > Number > Date, or use a custom format such as dd/mm/yyyy depending on your locale. When you run calculations, remember that time components (hours, minutes) can also appear if your source dates include times. In most scheduling tasks, you’ll only need the date portion, not the time portion.
Basic arithmetic: add days with simple formulas
The simplest way to add days is to use arithmetic. If A2 contains a date and you want to add 10 days, enter =A2 + 10. If you want to drive the offset from another cell, say B2 contains the number of days to add, use =A2 + B2. You can fill this formula down to apply it to an entire column. For clarity, you might wrap the date in DATEVALUE if you’re starting from text dates: =DATEVALUE(A2) + 7. Dragging the fill handle copies the formula to adjacent cells automatically.
Handling text dates and conversion
Sometimes dates arrive as text (e.g., from imports). In that case, convert first using DATEVALUE to turn the text into a true date serial number before adding days. Example: =DATEVALUE(A2) + 5. If your locale uses nonstandard separators (like 12/31/2024 vs 31/12/2024), DATEVALUE logic may vary, so test a few examples. After conversion, format the result as a date. If you need to preserve the original text, place the converted date in a adjacent column rather than overwriting.
Work with business days: networkdays and workday
If your goal is to move dates along a business calendar, use WORKDAY (start_date, days, [holidays]) to jump forward by workdays only. For example, =WORKDAY(A2, 8) returns the date eight working days after A2, skipping weekends and any listed holidays. To count backward, use a negative days value, e.g., =WORKDAY(A2, -5). For more control, WORKDAY.INTL lets you customize which days of the week are weekends. These functions enable practical scheduling without manual exclusion rules.
Advanced variations: months, years, and calendar math
Sometimes you must advance by months or years rather than days. Use EDATE to shift a date by a number of months: =EDATE(A2, 3) adds three months. To find the end of the month after adding months, wrap with EOMONTH: =EOMONTH(A2, 1) returns the last day of the next month. For date calculations tied to a year boundary, combining DATE with YEAR, MONTH, and DAY can give precise control. Remember to format the final result as a date to keep your sheet readable.
Practical workflow: building a reusable date calculator template
A robust approach is to build a small template you can reuse across projects. Create a header row with labels like Start Date, Offset (days), Result Date, and Notes. Use absolute references in named ranges to avoid mistakes when dragging formulas across sheets. Add data validation on the Offset column to restrict to reasonable values (e.g., -365 to 365). Finally, include a simple chart or conditional format to visualize upcoming dates, which helps you catch overdue items at a glance.
Tools & Materials
- Computer or device with internet access(Essential for accessing Google Sheets)
- Google account with Sheets(Needed to open and edit spreadsheets)
- Sample date in a cell (e.g., A2)(Base date to which days will be added)
- Notebook or digital notes(Optional for planning your offsets)
- Spreadsheet with a date column(Helps practice the formulas)
Steps
Estimated time: 30-45 minutes
- 1
Open your sheet and locate the date cell
Identify the cell that contains the start date (e.g., A2). Confirm that the cell is formatted as a date for reliable arithmetic.
Tip: If the date is in text form, convert it first with DATEVALUE before proceeding. - 2
Decide how many days to add
Enter the number of days to add in a separate cell (e.g., B2) or choose a fixed offset you’ll apply in the formula.
Tip: Use data validation on the offset cell to prevent invalid entries. - 3
Apply the simple addition formula
In the destination cell, type =A2 + B2 (or =A2 + 7 to add a fixed seven days). Press Enter to calculate the new date.
Tip: Format the destination cell as Date to ensure readability. - 4
Copy the formula down the column
Drag the fill handle from the destination cell downward to apply the same calculation to additional rows.
Tip: If you add new rows, ensure the formula references extend automatically. - 5
Handle text dates if needed
If A2 is text, wrap the date conversion: =DATEVALUE(A2) + B2. Then format as Date.
Tip: DATEVALUE may require locale-aware adjustments; test with a sample date. - 6
Explore business days and advanced variants
Use WORKDAY(A2, offset) to skip weekends and holidays or EDATE for month shifts. These expand your date arithmetic toolkit.
Tip: Keep a list of holidays handy for accurate WORKDAY results. - 7
Validate results and clean up
Spot-check a few results against your expectations, then tidy formatting, borders, and notes to maintain clarity.
Tip: Add a brief note column to explain the offset logic for anyone reviewing the sheet.
FAQ
How can I add days to a date without modifying the original date?
Place the formula in a new column (e.g., =A2 + 7). This leaves the original date intact while showing the calculated date. You can later hide or lock the original column if needed.
Put the calculation in a new column so your original date stays unchanged.
What if the date is stored as text?
Convert with DATEVALUE first, then add days (e.g., =DATEVALUE(A2) + 5). Ensure the cell is formatted as Date after conversion.
Convert the text date with DATEVALUE, then add days.
How do I add days while skipping weekends?
Use WORKDAY(start_date, days, [holidays]) to move forward by workdays only. Provide zero holidays or a holidays range to tailor the calendar.
Use WORKDAY to advance dates by working days only.
Can I move dates by months instead of days?
Yes. Use EDATE(start_date, months) to shift by whole months. For end-of-month alignment, combine with EOMONTH as needed.
Use EDATE to shift dates by months.
What should I do if I need to subtract days?
Use a negative offset in the same formula, e.g., =A2 - 10, or =WORKDAY(A2, -5) for workdays back.
Just use a negative offset to subtract days.
Is there a quick way to extend a date across a range?
Yes. Use an array formula or fill handle to propagate a formula down a column, ensuring your ranges are properly anchored.
Fill down the formula to extend dates across rows.
Watch Video
The Essentials
- Use simple arithmetic to add days: =Date + offset.
- Convert text dates with DATEVALUE before arithmetic.
- Explore WORKDAY and EDATE for business days and monthly shifts.
- Format results as Date to ensure readability.
- Create reusable templates for consistent date calculations.
