Hello!
Good day!
I need help.
I want to add date in each cell base on the given no of days and starting date.
Scroll bar should be added also to be able to scroll on dates.
This is my workbook.
Thanks in advance.
Printable View
Hello!
Good day!
I need help.
I want to add date in each cell base on the given no of days and starting date.
Scroll bar should be added also to be able to scroll on dates.
This is my workbook.
Thanks in advance.
Hi
In D5 and copied across,
=IF(COLUMNS($D5:D5)<=$B$1,IF(COLUMNS($D5:D5)=1,$B$ 2,C5+1),"")
In Scrollbar's property, type B1 in LinkedCell, set Max as required.