Add interval to date in Excel
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?
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.
You can find similar Excel Questions and Answer hereunder
1) How can I add a Footer to my printout with automatic page numbering?
2) How to do date and time zone conversion in excel in Excel
3) How can I add Trendline to a chart using VBA?
4) How can I dynamically add a hyperlink using VBA?
5) How to add a link in a sheet to another sheet
6) Every time I make an update to my Worksheet, I would like to add a timestamp to my Last Updated field. In Excel, how can I do that in Worksheet?
7) How can I add a 3 Month Moving average Trend line to my line chart?
8) How do I enter a formula in a cell using VBA (using Relative Reference)?
9) How do I add a shape using VBA?
10) How can I find time interval between 2 times?