How to auto add X number of days to a column in Microsoft Office Excel

I was preparing weekly schedule/roster for my team and I needed to alternate the schedule between two groups on a weekly basis, i.e. 7 days from first Sunday in 2016 to the last Sunday in 2016. I accomplished the task by auto adding 7 days to column first Sunday column.

Below was the steps I followed to accomplished the task.

1. First I created the date and the group columns, i.e. A and B cells
2. On the Date column (A2), I entered the first Sunday i.e. 03/01/2016
3. In cell A3, I entered =A2 + 7 and pressed enter, this produced the date 10/01/2016
4. I selected the cell A3
5. I then moved the cursor to the lower right hand corner of the cell A3. Note, at the lower right corner, the cursor should changed to plus sign(+)
6. I then dragged the cell down to cell A55, i.e. until the last Sunday of the year – 25/12/2016

Excel 2016 All-in-One For Dummies
Excel 2016 All-in-One For Dummies - Paperback (816 pages)
by Greg Harvey
Price: £14.11
You save: £2.65 (9 %)
36 new from £14.118 used from £16.55
Your one-stop guide to all things Excel 2016 Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic and beyond. In no time, your Excel skills will go from 'meh' to excellent. Written by expert Greg Harvey, who has sold more than 4.5 million copies of his previous books combined and has taught and trained extensively in Microsoft Excel, this all-encompassing guide offers everything you need to get started with Excel. From generating pivot tables and performing financial functions to performing error trapping and building and running macros and everything in between this hands-on, friendly guide makes working with Excel easier than ever before. * Serves as the ideal reference for solving common questions and Excel pain points quickly and easily * Helps to increase productivity and efficiency when working in Excel * Fully updated for the new version of Excel * Covers basic and more advanced Excel topics If working in Excel occasionally makes you want to scream, this will be the dog-eared, dust-free reference you'll turn to again and again.

Post Comment