Forum Discussion
MarkS9198
Jul 27, 2022Copper Contributor
Shifting Time Series Data forward in time
I have an excel table that calculates monthly cashflows over time. I want to duplicate it, slide everything down 1 month, and repeat this process for a total of 60 months, then be able to have a gra...
Jul 27, 2022
Hi MarkS9198
To shift the time one month you can add 1 as in this formula:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A13))
Assuming that your date in cell A1