Help needed: How can I insert regular interval dates in excel row

joneill · #1 11-21-2014, 09:33 AM

Quote:

Originally Posted by Pecoflyer

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel is changing dates.	laqa	Excel	5	11-06-2014 07:26 PM
Macro Needed to Insert Asnwer to A Question in Multiple Choice Format Question	rsrasc	Word VBA	7	03-28-2014 12:28 PM
Grouping Dates in Excel Pivot Table	mskennedy	Excel	2	02-27-2013 11:09 AM
Excel 2010 - Converting fractions into dates	judicial85	Excel	5	12-31-2011 07:59 AM
MS Excel 2004 for Mac - copying dates between documents	BCRenton	Excel	4	11-10-2009 07:28 AM