Use the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another. Then type a formula like one of the following. Warning: If the Start_date is greater than the End_date, the result will be #NUM!.

Manage account. Change the email address or phone number for your Microsoft account. Add or remove an Xbox profile. Delete your Microsoft account security info. Check your Microsoft account balance. Earn points with Microsoft Rewards. Update your Microsoft account if you’re moving to a new country or region. How to delete a child account.

Repair an Outlook data file (.pst) file. Open SCANPST.EXE. Select Browse to select the Outlook Data File (.pst) you want to scan. If you need help locating your Outlook Data File, see Locating the Outlook Data Files. Note: By default, a new log file is created during the scan.

With Word you can: Create a document from scratch or from a template. Add text, images, art, and videos. Research a topic and find credible sources. Access your documents from a computer, tablet, or phone via OneDrive. Share your documents and collaborate with others. Track and review changes. On the File tab, select New. Select Blank document ...

Your table of contents will still be there. To customize your existing table of contents: Go to References > Table of Contents. Select Custom table of contents. Use the settings to show, hide, and align page numbers, add or change the tab leader, set formats, and specify how many levels of headings to show. For more info, see Custom table of ...

Schedule a meeting or event. From the calendar, select New Event. Add a title for your meeting or event. Select Invite attendees, then enter names of individuals to invite to the meeting or event. Select a suggested time slot, or manually enter a date and start and end times. Enter a meeting location, and slide either the Skype or Teams meeting ...

Syntax. =TEXTSPLIT (text,col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with]) The TEXTSPLIT function syntax has the following arguments: text The text you want to split. Required. col_delimiter The text that marks the point where to spill the text across columns. row_delimiter The text that marks the point where to spill ...

The following tips can help you pinpoint the issue affecting your device. Before you begin, make sure your device is plugged into a power source and connected to the internet. Then, try the steps listed below to get your PC to update. Some updates require administrator access. If your account doesn't have administrator access, see Create a ...

Use desktops to keep different tasks organized or for different parts of your life, like work and home. To create a new desktop, select Task view > New desktop. To switch between desktops, select Task view . To change a background on a desktop, in Task view, right-click (or press and hold) on the desktop and select Choose background.

Transfer your files to your new PC. Connect your external storage device to your new Windows 11 PC. Select File Explorer from your task bar. On the left guide bar, select This PC. Locate the external drive and double-click its corresponding icon. Locate the folder where your files are saved, and then double-click that folder's icon.