Thread: [Solved] Help needed: How can I insert regular interval dates in excel row
View Single Post
 
Old 11-21-2014, 09:33 AM
joneill joneill is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Nov 2014
Posts: 3
joneill is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
Hi
enter the date of the first monday in A3. Supposing you want to stay in row 3, in B3 enter =a3+7 and drag right as far as needed
Thanks for your response Pecoflyer I realised my OP is incorrect I want to stay in row 1 across different columns starting from C1 going across. I tried to take your advice typing "=C1+7" in cell D1 but the dragging part didn't seem to work for me, all it did was try to total the value of all the selected cells and place that in cell D1
Reply With Quote