add interval to date in Excel

Q54. In Excel, how can I add interval to dates?

For example, I track my deposits and withdrawals every Wednesday as shown below. Instead of manually typing the dates, is there any way I can use a formula to get the dates?

excel add interval to date

To do it in Excel, here is the answer:

a) Enter the first date (02-Aug-17 in this case). Enter the formula =DATE(YEAR(B3)+0,MONTH(B3)+0,DAY(B3)+7) in the next cell. Drag the formula all the way down to end of Date column.

This formula can be used to introduce any interval to dates (any combination of years, months and days) or to add any duration to dates.

Since in the current example, the interval required is "weekly", value added to Year and Month are 0 while it is 7 for days.

excel excel add interval to date

 

You can find similar Excel Questions and Answer hereunder

1) How can I add Trendline to a chart using VBA?

2) How can I dynamically add a hyperlink using VBA?

3) How can I add a Timestamp after macro execution?

4) How can I add a Footer to my printout with automatic page numbering?

5) How can I add a legend to a chart using VBA?

6) How can I find the day of the week given a date?

7) Can I add a small chart to Table data to make it visually appealing and easy to interpret?

8) How can I find time interval between 2 times?

9) How can I add a Prefix to a set of numbers in a range?

10) How do I enter a formula in a cell using VBA (using Relative Reference)?

11) How do I enter a formula in a cell using VBA (using Absolute Reference)?

12) I want to add a trend indicator symbol next to my sales data - how can I do that?

13) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

14) How to do date and time zone conversion in excel in Excel

15) How can I dynamically add series to an existing chart using VBA?