Basically I need to create a spreadsheet in which Row A (from cell A3 onwards) contains the date of every Monday in 2015, cell by cell. I would rather not have to enter these manually, is there any way to automate this process somehow? Any help with this would be greatly appreciated.

Thanks,



Jonny

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

Enter the date of the first Monday in C1 then =C1+7 in D1 and drag right

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Here is an example in case you wanted to see it.

Attached Files

Dates plus 7.xlsx (8.8 KB, 10 views)

Thank you both for the help guys, I got sorted in the end although I used a slightly different method which I'll repost for reference. I typed my date in the first cell, highlighted every other cell I wanted to populate and then

Home tab | Fill | Series | select 'Date' and a step value of 7 then OK.

Thanks again for the info and support folks.