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,…
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…
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…
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…
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…
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…
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…
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…
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