Add or subtract dates - Microsoft Support
Add or subtract months from a date with the EDATE function. You can use the EDATE function to quickly add or subtract months from a date.. The EDATE function requires two arguments: the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Skype for Business help - Microsoft Support
Download and install Skype for Business on your PC. Sign in to and out of Skype for Business. Set up an audio device for Skype for Business. Set up and troubleshoot Skype for Business video
Applies To: Skype for Business, Skype for Business Basic, Skype for Business for Mac, Skype for Business Online
Attach files in Outlook - Microsoft Support
Caution: Don't open an attachment sent in an email message unless you trust the content and the person who sent it to you.Attachments are a common method for spreading computer viruses. In the email message, select Preview from the drop-down menu next to the attachment to view the contents of the attachment without opening it.
Applies To: Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016
Install, manage, or uninstall apps in Microsoft Edge
Alternatively, you can install any website by going to the top corner of the browser and select Settings and more … > Apps > Install this site as an app.
Applies To: Microsoft Edge
RAND function - Microsoft Support
=RAND()*(b-a)+a. If you want to use RAND to generate a random number but don't want the numbers to change every time the cell is calculated, you can enter =RAND() in the formula bar, and then press F9 to change the formula to a random number. The formula will calculate and leave you with just a value.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Open and find items in an Outlook Data File (.pst)
Expand the top level of the Outlook data file in the Outlook Navigation pane to see the subfolders in the file. Click each subfolder to see the contents.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Product activation for Windows – online & support telephone numbers
To activate Windows 10 using an internet connection: As Windows 10 will automatically activate if you are connected to the internet, you can confirm your activation status by selecting Start > Settings > Update & Security > Activation and looking under Windows.. If online activation fails, first try the activation troubleshooting in Activate Windows 10.
IFS function - Microsoft Support
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac
Change or update email account settings in Outlook for Windows
Sometimes you need to make a change to your email account settings. If you have a new password, if your email provider has asked you to change settings, or if you're having problems with sending and receiving email, you can change your email account settings through Mail in the Windows Control Panel, or from Outlook.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
DATEDIF function - Microsoft Support
Argument. Description. start_date . Required. A date that represents the first, or starting date of a given period. Dates may be entered as text strings within quotation marks (for example, "2001/1/30"), as serial numbers (for example, 36921, which represents January 30, 2001, if you're using the 1900 date system), or as the results of other formulas or functions (for example, DATEVALUE("2001 ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, SharePoint Foundation 2010, SharePoint Server 2010, Windows SharePoint Services 3.0