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
Edit a PDF - Microsoft Support
To edit a PDF, open it in Word. This works best with PDFs that are mostly text. PDFs of book chapters or something that looks like a manuscript from a copier won't be formatted well in Word.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Recover lost files on Windows 10 - Microsoft Support
If you can’t locate a lost file from your backup, then you can use Windows File Recovery, which is a command line app available from the Microsoft Store.Use this app to try to recover lost files that have been deleted from your local storage device (including internal drives, external drives, and USB devices) and can’t be restored from the Recycle Bin.
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
Turn off Defender antivirus protection in Windows Security
Select the Windows Security app from the search results, go to Virus & threat protection, and under Virus & threat protection settings select Manage settings.
Setup OneDrive for Microsoft 365 for business
OneDrive is your online cloud storage within Microsoft 365. It lets you store your individual work files that you don't want your colleagues to have access to unless you choose to share the files with them.
Create a system restore point - Microsoft Support
In the search box on the taskbar, type Create a restore point, and select it from the list of results.
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
Manage app permissions for your camera in Windows
To use your camera with apps on Windows 10, you'll need to turn on some permissions in Camera settings. Then, you'll need to check your app permissions if you want to use your camera with apps.
Signing in with a passkey - Microsoft Support
Creating a passkey. To create a passkey for your Microsoft account, follow these steps on the device for which you’d like to create a passkey:
Applies To: Microsoft account dashboard