Using a spreadsheet to automatically create a list of dates

Something that I witness far too often for my liking, is people manually entering a list of patterned dates into something – e.g. if someone is creating a scheme of work, where they want every Tuesday for a year, they sit there with a paper diary in front of them, flicking through the pages and manually typing in the date of every single Tuesday in the year. This is very time consuming, and prone to mistake.

Personally, I let the technology do the work for me, and usually spreadsheet software (e.g. Microsoft Excel).

Here is a short video showing 2 different techniques of how you can get Excel to create a list of dates that follow a pattern.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: