Auto update of Data (Dates, Time, etc.) in next sheet created

[raqureshi78]

Hello Friends,

Can you help me figure out with any formula of script that if I create a copy of existing sheet the data (dates, times etc.) contained in it will auto update in the next sheet created.

For example,

In the first sheet I have 5 cells with dates ( 1 jan, 2 jan, 3 jan, 4 jan, 5 jan), when I create a copy of same sheet I have to formulate (1 jan ) of sheet 2 to fetch last date of first sheet + 1 so that in sheet 2 the first date should be the subsequent to 5 jan that is it will 6 jan and than "1" is added to subsequent dates till the last date in the fifth cell is 10 jan.
kindly share your expert view/suggestion.

Your help will be highly appreciated.

[Tryskall]

You have to create the first two sheets, then create a third form the second.
First cell with date on second sheet
=sheet1(a5)+Duration 0,1
Once you create the second sheet you can copy the second to make the third and so on...
With duration the 0 is the week and 1 is the day...sometimes the formula doesn’t copy correctly and thus changes the week. So double check the formula the first time thru... good luck.