I was training the other day and demonstrating sequences with dates, working days etc. Someone asked me whether they could quickly put all Monday and Wednesday dates into a worksheet as these were the days maintenance staff were on site.
Enter the first two Monday and Wednesday dates.
Select both cells and then use the fill handle to drag down.
From the Auto Fill Options button, select Fill Weekdays.
You will then have all Mondays and Wednesdays!
Find out more about our Microsoft Excel training London, UK.
Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.