Excel Shortcuts: Build A Quick Weekday Date List in Excel
Now that the holiday season is over (almost 2 weeks ago now) I’ve finally got myself back into a routine and I wanted to start off the year with a quick tip for those of you looking on how to build a list of weekday dates for your planning purposes and to get the year started off right. This simple trick can be used to build a quick calendar to record daily sales, production numbers, number of orders shipped etc.
You’ll notice that when using the auto fill option located in the bottom right hand corner of the current cell that you’ve highlighted, that as you drag the mouse over other cells, the dates automatically populate in chronological order. The only problem here is that you only want to include weekdays and not all days of the week. This post will show you how to easily and quickly only show the weekdays in the calendar that you’re building. (more…)
