Add Week Numbers to Outlook Calendar
john lilleystone • January 2, 2019
Displaying the week number in your Outlook calendar is handy. Here's how to switch them on.
So here's the default view (i.e. with no week numbers on)
To add the week number go to File>Options>Calendar. Tick the
box Show Week Numbers in the month view and in the Date Navigator
and click on OK.
When you click on OK, you should see the week number against each week in the Calendar!
Replace ugly Excel errors returned by a formula with something more appropriate and pleasing to the eye.
Use the RANDBETWEEN function in Excel to randomly generate numbers between a specified upper and lower threshold.
Don't waste time manually editing queries to move the date period on one month. This blog explains how to use DATEADD to dynamically shift the dates on one month on each refresh
Import text files into Excel and use the Text to Columns wizard to separate the data into columns
