How to calculate the number of months between two dates in Excel

SUMMARY loadTOCNode(1, \'summary\'); This step-by-step article shows you how to calculate the number of months between any two dates. To calculate the number of months between any two dates, use one of the following methods. Note that both methods use the following information: EDate = Earlier Date LDate = Later DateNOTE: If you type LDate or EDate directly into this formula instead of into their cell references, you must surround it by quotation marks (for example, "9/7/00"). Round Up loadTOCNode(2, ... Read more..

Posted in MS Office Excel No Comments »

AddThis Social Bookmark Button

You may not be redirected to the correct Web site when you click a hyperlink in Excel, in PowerPoint, or in Word

You may not be redirected to the correct Web site when you click a hyperlink in Excel, in PowerPoint, or in WordView products that this article applies to.Article ID:949282Last Review:March 5, 2008Revision:1.0SYMPTOMSConsider the following scenario:•You click a hyperlink in a document in one of the following Microsoft Office programs:•Microsoft Office Excel 2007•Microsoft Office Excel 2003•Microsoft Office PowerPoint 2007•Microsoft Office PowerPoint 2003•Microsoft Office Word 2007•Microsoft Office Word 2003•The hyperlink redirects you to another Web site.In this scenario, you ... Read more..

Posted in MS Office Excel, MS Office Powerpoint No Comments »

AddThis Social Bookmark Button

You cannot install or start Windows Vista when the volume of the system partition is larger than 2 terabytes

You cannot install or start Windows Vista when the volume of the system partition is larger than 2 terabytesView products that this article applies to.Article ID:946557Last Review:May 12, 2008Revision:1.1On This PageSYMPTOMSYou cannot install or start Windows Vista when the volume of the system partition is larger than 2 terabytes (TB).Back to the topCAUSEThis issue occurs for one of the following reasons: •You configure the master boot record (MBR) disk as the boot partition.When the MBR disk is used ... Read more..

Posted in Vista Center, Vista Easter Eggs, Vista HowTo, Vista Tips, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

The DHCP Server service on a Windows Server 2008-based computer interprets DHCPv6 Option 39 incorrectly

Article ID: 953269 - Last Review: December 2, 2008 - Revision: 1.0The DHCP Server service on a Windows Server 2008-based computer interprets DHCPv6 Option 39 incorrectlyHotfix Download AvailableView and request hotfix downloadsView products that this article applies to.On This PageExpand all | Collapse allSYMPTOMSThe Dynamic Host Configuration Protocol (DHCP) Server service on a Windows Server 2008-based computer interprets DHCPv6 Option 39 incorrectly. This behavior occurs when a DHCP client sends its fully qualified domain name ... Read more..

Posted in Commerce Server 2007, Microsoft Exchange Server, Microsoft SQL Server, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

You cannot see a video camera in the Scanners and Cameras item in Control Panel after you connect the video camera to a Windows Vista-based computer

You cannot see a video camera in the Scanners and Cameras item in Control Panel after you connect the video camera to a Windows Vista-based computerView products that this article applies to.Article ID:927833Last Review:March 15, 2007Revision:1.5SYMPTOMSAfter you connect your video camera to a Windows Vista-based computer, you cannot see the video camera in the Scanners and Cameras item in Control Panel. This behavior differs from the behavior of Microsoft Windows XP.Back to the topCAUSEThis behavior occurs because the Windows Image ... Read more..

Posted in Vista Center, Vista Easter Eggs, Vista HowTo, Vista Tips, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

Error message when you try to use the Windows Fax and Scan feature to send a fax in Windows Vista: The message could not be sent. An error has occurred.

Error message when you try to use the Windows Fax and Scan feature to send a fax in Windows Vista: “The message could not be sent. An error has occurred.”View products that this article applies to.Article ID:930130Last Review:March 15, 2007Revision:1.2On This PageSYMPTOMSWhen you try to use the Windows Fax and Scan feature to send a fax in Windows Vista, you cannot send the fax. Additionally, you receive the following error message:The message could not be sent. An error ... Read more..

Posted in Vista Center, Vista Easter Eggs, Vista HowTo, Vista Tips, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

You receive an error message when you use a Windows Vista Sidebar gadget that has an event that is set to null

You receive an error message when you use a Windows Vista Sidebar gadget that has an event that is set to nullView products that this article applies to.Article ID:927825Last Review:May 16, 2007Revision:1.5On This PageSYMPTOMSWhen you use a Windows Vista Sidebar gadget, you receive an error message that resembles the following:A Runtime Error has occurred. Do you wish to Debug? Line: <line number> Error: Unspecified error.Back to the topCAUSEThis problem occurs if the gadget's script code ... Read more..

Posted in Vista Center, Vista Easter Eggs, Vista HowTo, Vista Tips, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

You may experience issues with the Windows Aero feature on a Windows Vista-based computer

When you start a Windows Vista-based computer, or when you use a Windows Vista-based computer, you may experience one of the following issues: • You may be unable to turn on the Windows Aero feature. Or, you may be unable to turn on some options in the Windows Aero feature. • The Windows Aero feature may be turned off after minutes of activity. CAUSE This issue occurs because the Windows Aero feature has specific hardware requirements, software configuration requirements, and resource requirements that must be met ... Read more..

Posted in Visual Help No Comments »

AddThis Social Bookmark Button

Pinball Easter Eggs

Pinball Easter Eggs 1. Type 1max at the start of a new ball to get extra balls. 2. Type gmax at the start of a new game to activate the Gravity Well. 3. Type rmax at the start of a new game to go up in ranks. 4. Type bmax at the start of a new ball. This will give you unlimited balls. Once this is activated you will be unable to activate other secrets without restarting the game. Second Easter Egg Open Pin Ball ... Read more..

Posted in XP Easter Eggs No Comments »

AddThis Social Bookmark Button

Description of the CheckSUR update for Windows Vista and for Windows Vista for x64-based systems

Description of the CheckSUR update for Windows Vista and for Windows Vista for x64-based systemsView products that this article applies to.Article ID:947821Last Review:March 13, 2008Revision:1.1Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to ... Read more..

Posted in Vista Center, Vista Easter Eggs, Vista HowTo, Vista Tips, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

An error code is returned when a Kerberos client requests a TGT against a Windows Server 2008-based domain controller: KERB5KDC_ERR_C_PRINICPAL_UNKNOWN

An error code is returned when a Kerberos client requests a TGT against a Windows Server 2008-based domain controller: KERB5KDC_ERR_C_PRINICPAL_UNKNOWNView products that this article applies to.Article ID:951191Last Review:May 16, 2008Revision:2.0On This PageSYMPTOMSConsider the following scenario: •A client performs Kerberos authentication against a Windows Server 2008-based domain controller.•The client requests a ticket-granting ticket (TGT) by specifying the host principal name as the client name in the KRB_AS_REQ packet.In this scenario, authentication fails, and the following error code is returned:KERB5KDC_ERR_C_PRINICPAL_UNKNOWNThis problem may occur ... Read more..

Posted in Commerce Server 2007, Microsoft Exchange Server, Microsoft SQL Server, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

SharePoint Services may not function as expected in the Turkish locale

SharePoint Services may not function as expected in the Turkish localeView products that this article applies to.Article ID:923280Last Review:June 5, 2008Revision:1.0On This PageSYMPTOMSYou may experience one of the following problems on a server that is set to the Turkish locale:•You set the locale of a SharePoint site to Turkish. When you try to edit the permissions of a document library in the site, you receive the following error message:Operation is not valid due to the current state of the object.•A ... Read more..

Posted in MS Office SharePoint No Comments »

AddThis Social Bookmark Button

When you open a Word 2007 document that is protected by a password on a network share, the document is opened as read-only

Article ID: 956937 - Last Review: November 26, 2008 - Revision: 1.0When you open a Word 2007 document that is protected by a password on a network share, the document is opened as read-onlyView products that this article applies to.Expand all | Collapse allSYMPTOMSWhen you open a Microsoft Office Word 2007 document that is protected by a password on a network share, the document is opened as read-only. You expect to be prompted for a password ... Read more..

Posted in Apple Products, Microsoft .NET Framework, Microsoft Exchange Server, Microsoft SQL Server, MS Office Access, MS Office Accounting, MS Office Excel, MS Office Groove, MS Office InfoPath, MS Office OneNote, MS Office Outlook, MS Office Powerpoint, MS Office Project 2007, MS Office Publisher, MS Office SharePoint, MS Office Suite 2007, MS Office Visio, MS Office Word No Comments »

AddThis Social Bookmark Button

Some features in QuickBooks 2006 and in earlier versions may not work as expected on a Windows Vista-based computer

Some features in QuickBooks 2006 and in earlier versions may not work as expected on a Windows Vista-based computerView products that this article applies to.Article ID:936650Last Review:October 31, 2007Revision:1.4SYMPTOMSOn a Windows Vista-based computer, some features in Intuit QuickBooks 2006 and in earlier versions may not work as expected. For example, the Payroll Services feature may not work correctly.Back to the topCAUSEThis behavior may occur because of compatibility issues that occur when you use Intuit QuickBooks 2006 and earlier versions ... Read more..

Posted in Vista Center, Vista Easter Eggs, Vista HowTo, Vista Tips, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

Error message when you put a Windows Vista-based computer to sleep while a PPP connection is active: STOP 0x0000009F

Error message when you put a Windows Vista-based computer to sleep while a PPP connection is active: STOP 0x0000009FView products that this article applies to.Article ID:931671Last Review:August 29, 2007Revision:4.0On This PageSYMPTOMS You are using Point-toPoint Protocol (PPP) to connect to a network or to the Internet from a Windows Vista-based computer. If you put the computer to sleep while the PPP connection is active, the screen goes black. After approximately 10 minutes, your computer may restart, ... Read more..

Posted in Vista Center, Vista Easter Eggs, Vista HowTo, Vista Tips, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

The BitLocker Drive Encryption program may become unresponsive on a Windows Vista Ultimate-based computer

The BitLocker Drive Encryption program may become unresponsive on a Windows Vista Ultimate-based computerView products that this article applies to.Article ID:929836Last Review:January 26, 2007Revision:1.1SYMPTOMSWhen you try to run the BitLocker Drive Encryption program on a Windows Vista Ultimate-based computer, the program may become unresponsive. Specifically, the % Completed value in the BDE dialog box does not continue to progress.Back to the topCAUSEThis problem may occur if the BitLocker Drive Encryption program tries to encrypt data on ... Read more..

Posted in Vista Center, Vista Easter Eggs, Vista HowTo, Vista Tips, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

How to use the BitLocker Recovery Password Viewer for Active Directory Users and Computers tool to view recovery passwords for Windows Vista

How to use the BitLocker Recovery Password Viewer for Active Directory Users and Computers tool to view recovery passwords for Windows VistaView products that this article applies to.Article ID:928202Last Review:October 26, 2007Revision:3.2On This PageINTRODUCTIONThis article describes how to use the BitLocker Recovery Password Viewer for Active Directory Users and Computers tool. The BitLocker Drive Encryption feature is a data protection feature that is included with the following versions of Windows Vista:•Windows Vista Ultimate•Windows Vista EnterpriseYou can use this tool ... Read more..

Posted in Vista Center, Vista Easter Eggs, Vista HowTo, Vista Tips, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

Windows Vista does not enumerate an IEEE 1394a device that you connect to the computer

Windows Vista does not enumerate an IEEE 1394a device that you connect to the computerView products that this article applies to.Article ID:927827Last Review:March 15, 2007Revision:1.4SYMPTOMSWhen you connect an IEEE 1394a device to a computer that is running Windows Vista, Windows Vista does not enumerate the device. However, if you connect the same device to a computer that is running Microsoft Windows XP, Windows XP enumerates the device successfully.Note An IEEE 1394a device may also be referred to as a FireWire ... Read more..

Posted in Vista Center, Vista Easter Eggs, Vista HowTo, Vista Tips, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

The optical disk drive on a ThinkPad X300 computer that is running Windows Vista is not recognized after you perform a suspend-and-resume cycle or a hibernate-and-wake cycle on the computer

The optical disk drive on a ThinkPad X300 computer that is running Windows Vista is not recognized after you perform a suspend-and-resume cycle or a hibernate-and-wake cycle on the computerView products that this article applies to.Article ID:949634Last Review:March 19, 2008Revision:1.0On This PageSYMPTOMSConsider the following scenario: •On a ThinkPad X300 computer that is running Windows Vista, you enable the Disable optical drive option on the Power Management tab.•You perform a suspend-and-resume cycle or a hibernate-and-wake cycle on the computer.In this scenario, ... Read more..

Posted in Vista Center, Vista Easter Eggs, Vista HowTo, Vista Tips, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips No Comments »

AddThis Social Bookmark Button

Detection and deployment guidance for the August 12, 2008 security release

Detection and deployment guidance for the August 12, 2008 security releaseView products that this article applies to.Article ID:956636Last Review:August 13, 2008Revision:2.0On This PageINTRODUCTIONAs part of an ongoing commitment to provide detection tools and deployment recommendations for security updates, Microsoft is delivering this detection and deployment guidance for all updates that are released during a Microsoft Security Response Center (MSRC) release cycle.This guidance contains recommendations that are based on the kinds of scenarios that may exist in various Microsoft operating system ... Read more..

Posted in App HowTo, Apple Products, Application Center, Commerce Server 2007, Internet Explorer 7, Microsoft .NET Framework, Microsoft Exchange Server, Microsoft SQL Server, MS Office Access, MS Office Accounting, MS Office Excel, MS Office Groove, MS Office InfoPath, MS Office OneNote, MS Office Outlook, MS Office Powerpoint, MS Office Project 2007, MS Office Publisher, MS Office SharePoint, MS Office Suite 2007, MS Office Visio, MS Office Word, MS Visual Studio, Vista Center, Vista Easter Eggs, Vista HowTo, Vista Tips, Visual Help, VS General, Win XP Center, Windows Defender, Windows Server 2008, Windows Server 2008 - HowTo, Windows Server 2008 - Tips, XP HowTo No Comments »

AddThis Social Bookmark Button


Page 5 of 156123456789101112...203040...Last »