Learn how to download, install, and use the PC Health Check app to check your device's compatibility with Windows 11 and get tips to improve its performance.

Here's the formula in a form you can copy and paste. If you want to play with it in a sample workbook, see the end of this article. =OR (AND (C2>DATE (2011,4,30),C2<DATE (2012,1,1)),B2="Nancy") Let's go a bit deeper into the formula. The OR function requires a set of arguments (pieces of data) that it can test to see if they're true or false.

In the following example, you'll see how to add and subtract dates by entering positive or negative numbers. Enter the number of days to add or subtract in column B. You can enter a negative number to subtract days from your start date, and a positive number to add to your date. In cell C2, enter =A2+B2, and copy down as needed.

Learn how to troubleshoot and fix problems setting up your email in Outlook.

When you customize your ribbon: Your customizations apply only to the Office program you're working in at the time. For example, if you personalize your ribbon in PowerPoint, those same changes won't be visible in Excel. If you want similar customizations in your other Office apps, you'll have to open each of those apps to make the same changes.

Can I upgrade to Windows 11? If your existing Windows 10 PC is running the current version of Windows 10 and meets the minimum hardware specifications to run Windows 11, it will be able to upgrade.

Set up your Windows device for cloud gaming Note Cloud gaming does not support local multiplayer, it only supports one player and one account at a time.

Learn how to run Windows Update Troubleshooter to resolve errors downloading or installing Windows updates.

Sync your files between Windows devices and the cloud with OneDrive. Learn how to install, use, and troubleshoot OneDrive with Microsoft Support.

Edit a drop-down list that's based on an Excel Table. If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add an item, go to the end of the list and type the new item. To remove an item, press Delete.