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
Switch to the new Microsoft Teams - Microsoft Support
When in the new Teams, turn on (or off) notifications by selecting Settings and more at the top of the new Teams, then selecting Settings > Notifications > Open Windows notifications settings.Find Microsoft Teams (work preview) in the apps list and set your preference.
Applies To: Microsoft Teams
Internet Explorer mode in Microsoft Edge - Microsoft Support
To return to browsing without Internet Explorer mode, you can click Leave on the information bar at the top of the screen, or close your current tab and open a new tab in Microsoft Edge.
Download Office language interface packs (LIP) - Microsoft Support
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
How do I log on as an administrator? - Microsoft Support
Open User Accounts by clicking the Start button , clicking Control Panel, clicking User Accounts and Family Safety, clicking User Accounts, and then clicking Manage another account .. If you're prompted for an administrator password or confirmation, type the password or provide confirmation.
Turn off Scroll Lock - Microsoft Support
Tip: To quickly open the On-screen Keyboard in Windows 11, click the Windows button.Begin typing On-Screen Keyboard which will appear in the search entry box. Under Search, which will appear as a list above the search box, click the On-Screen Keyboard search result. When the on-screen keyboard appears, click the ScrLk button.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Install a printer in Windows - Microsoft Support
Wait for it to find nearby printers, then choose the one you want to use, and select Add device.If you want to remove the printer later, select it, and then select Remove.
Format a date the way you want - Microsoft Support
When you enter some text into a cell such as "2/2", Excel assumes that this is a date and formats it according to the default date setting in Control Panel.Excel might format it as "2-Feb".If you change your date setting in Control Panel, the default date format in Excel will change accordingly.
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
Import or export text (.txt or .csv) files - Microsoft Support
Import a text file by opening it in Excel. You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Manage files and folders in OneDrive - Microsoft Support
Training: Get up and running quick. Note: If you already had an account signed in to OneDrive and you want to add another account, click the OneDrive cloud icon up in the Menu bar, click the three dots to open the menu, and select Preferences.Click the Account tab, select Add an Account to start OneDrive Setup, and then sign in.
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows