Liz has attended:
SharePoint course
Date formulas
I want to create a column with weekly dates in each row.
I have entered 24/8/15 in A4 and the formula =A4+7 in A5. This gives the value of 31/08/15. So far so good. But if I drag that formula down the column I just gets lots of 31/08/15. What am I doing wrong please?
RE: date formulas
Hi Liz,
Thank you for the forum question.
To me you are doing everything right.
Could the workbook been set to manual calculation?
Open the workbook and go to the Formulas tab. Click Calculation Options in the calculate group, Make sure that you have selected Automatic.
If this is not the problem I can have a look at the workbook. Please forward it to :
info@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
