Excel – How to fill a series of dates down a column

We provide our delegates with ongoing inspiration and support via short ‘How to’ videos that you can watch and learn from. The latest tips are little things that speed up your work, making you super-efficient. You’ll be well on your way to becoming a productivity Ninja!

This week’s tip is about how to quickly insert today’s date and create a series of dates down the column. You may want to copy this date down using the shortcut Ctrl + D or perhaps calculate different dates?

You can show incremental dates – today, tomorrow, the next day, or perhaps you want the date every 7 days? With this tip you can do it in seconds, deciding on the date it should stop. Watch my short ‘How to’ video to see how to do this in seconds.

Contact us on 01952 581550 for course dates and learn Excel with us!

If you would like a copy of the file I used in this exercise and step by step directions, sign up for our Tips & Tricks blog.

Contact us on 01952 581550 for course dates and learn Excel with us!

 

Tags: , , , , , , , ,