Excel 2016 – How to select smallest of multiple dates
The following examples show how to use an Excel formula to select the smallest date from a table. This may be useful where you have a table with duplicate information,…
Date
How to uninstall Meet Now in Windows 10 taskbar
The Windows 10 October 2020 update introduced a new feature - Meet Now. For the casual observer it's easily overlooked - but for others it's another annoying icon that sits…
Word 2016 – How to update a cross-reference
Cross-references in Word are useful for using the same footnote multiple times. However, they don't automatically update when new footnotes are inserted. For example - the footnote 'A type of…
Excel – How to calculate days until, between or after dates
The following Excel formulas show how to calculate the number of days for: Days until date Days between dates Days after date Days until date This formula shows how to…
Excel 2016 – How to edit worksheet header/footer
The following steps show how to edit a worksheet header/footer in Microsoft Excel. With the Excel document open, click on 'View' in the ribbon In the 'Workbook Views' group click…
Windows 10 – How to install Activity Directory (RSAT) tools
The steps below show how to install the Active Directory Users and Computers tool in Windows 10. IMPORTANT: The Active Directory Users and Computers tool is part of the Remote…
Windows 10 – How to tell which update version number installed
The following steps show how to tell which update version number of Windows 10 is installed. This will give you the exact version number, for example 1809. If you're looking…
T-SQL – How to output day name from date
The following T-SQL statement shows how output the name of a day from a date. For example, 16 March 2019 would output Saturday. SELECT DateName( weekday , GETDATE() ) as…
T-SQL – How to output day number from date
The following T-SQL statement shows how output the day from a date. For example, 16 March 2019 would output 16. SELECT DateName( day, GETDATE() ) as Day_From_Date