Adding days to a date helps in determining deadlines efficiently. It can be helpful in stock management and simplify many other administrative tasks.
3 Methods to add days to a date in Google Sheets:
- Use a formula where the same number of days have to be added
- Use a formula where a different number of days have to be added
- Use the End of Month formula
Let us begin.
Method #1: Use a Formula Where the Same Number of Days Have to Be Added
This is the simplest way to add days to a date. It is helpful if there is a database with a date field and you wish to add a particular number of days to all the dates.
Step #1: Open the Google Sheet
Open the Google sheet in which you have the date field and where you want to add days.
Step #2: Check the format
Ensure that the field is in Date format.
Select the desired column (in our case, column A) by clicking on the capital A.
Click on Format in the main menu bar.
In the drop down menu that opens, hover your mouse over the option Number.
From the submenu that opens, click on Date.
Step #3: Enter the formula
Double click on the adjacent cell to your date field, and type this formula:
=‘‘Cell Number’’ + x
- Cell Number is the cell in which your date is. In our case, it is A2.
- ‘x’ denotes the number of days to be added.
In our example, the end date of a particular work is 25 days after the start date. The start date is recorded in Column ‘A’. So, the required formula in our example will be
=A2+25.
Step #4: Press enter to get the result
Press enter to get the result for the first entry in the Google sheet.
Once the first field has been calculated, place your cursor on the field with the formula. In our example, that would be B2.
A blue frame will appear around the selected cell with a block in the bottom right corner. Click on that block, hold the mouse button in, and drag the cursor downwards to the last cell next to the last date. In our example, that would be B6.
Release the mouse button.
New dates will show in column B.
Method #2: Use a Formula Where Different Number of Days Have to Be Added
This method is more efficient if the number of days to be added differ.
Step #1: Open the Google Sheet
Open the Google sheet in which you have the date field and where you want to add days.
Step #2: Check the format
Ensure that the field is in Date format.
Select the desired column (in our case, column A) by clicking on the capital A.
Click on Format in the main menu bar.
In the drop-down menu that opens, hover your mouse over the option Number.
From the submenu that opens, click on Date.
Step #3: Enter the formula
Double click on the adjacent cell to your date field, and type this formula:
=Cell Number Column A+Cell Number Column B
- Cell Number Column A is the cell in which your date is. In our case, it is A2.
- Cell Number Column B is the cell containing the number of days to be added.
In our example, the formula will be
=A2+B2.
Step #4: Press enter to get the result
Press enter to get the result for the first entry in the Google sheet.
Once the first field has been calculated, place your cursor on the field with the formula. In our example, that would be C2.
A blue frame will appear around the selected cell with a block in the bottom right corner. Click on that block, hold the mouse button in, and drag the cursor downwards to the last cell next to the last date. In our example, that would be C6.
Release the mouse button.
New dates will show in column C.
Method #3: Use the End of Month Formula
This is useful when you need to set the date to a few days after the end of the month. Or if you want to add both a few months and a few days.
Step #1: Open the Google Sheet
Open the Google sheet in which you have the date field and where you want to add days.
Step #2: Check the format
Ensure that the field is in Date format.
Select the desired column (in our case, column A) by clicking on the capital A.
Click on Format in the main menu bar.
In the drop-down menu that opens, hover your mouse over the option Number.
From the submenu that opens, click on Date.
Step #2: Enter the formula
Double click on the adjacent cell to your date field, and type this formula:
=EOMONTH(Cell Number, y)+x
- Cell Number is the cell in which your date is. In our case, it is A2.
- y represents the number of months you wish to add.
- x represents the additional days to be added after the end of the month.
In our example, the formula will be
=EOMONTH(A2,0)+5
Step #4: Press enter to get the result
Press enter to get the result for the first entry in the Google sheet.
Once the first field has been calculated, place your cursor on the field with the formula. In our example, that would be B2.
A blue frame will appear around the selected cell with a block in the bottom right corner. Click on that block, hold the mouse button in, and drag the cursor downwards to the last cell next to the last date. In our example, that would be B6.
Release the mouse button.
New dates will show in column B.
Conclusion
Using the above methods will make your life easier and save you a lot of time. They also ensure that the output is error-free. Use any of the methods to add days to a date effectively.