Software
Comparison of Windows Server 2003 Editions
by John on Mar.17, 2010, under Operating System, Software, TIPS
Comparison of Windows Server 2003 Editions
Updated: March 28, 2003
Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2
The following table describes features supported by the Microsoft® Windows Server™ 2003 operating system, and illustrates which editions of the operating system support which features.
= Feature included
= Feature partially supported
= Feature not included
| Category | Feature and Description | Standard Edition | Enterprise Edition | Datacenter Edition | Web Edition |
| Hardware Specifications | 64-bit Support for Intel Itanium-based Computers(1)
Support for 64-bit processing delivers far higher scalability than 32-bit file servers by providing a greatly enlarged virtual address space and paged pool area, the ability to handle increased numbers of users and connections, and increased hardware reliability through predictive error checking and notification of failures. |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | Hot Add Memory(2, 3)
Hot Add Memory allows ranges of memory to be added to a computer and made available to the operating system and applications as part of the normal memory pool. This does not require rebooting the computer and involves no downtime. This feature only operates on servers that have hardware support for adding memory while the server is operating. Most existing servers do not have such hardware support and can be damaged if memory is installed while the power is on. It is recommended that you consult your server operator’s manual for more information. |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | Non-Uniform Memory Access(3)
As processor clock rates continue to increase and put pressure on processor bus architectures, scaling is addressed by implementing multiple processor buses. This can result in an architecture consisting of processors and memory arranged in smaller subsystems called nodes. Processor access time to memory in other nodes is longer than access time to memory in the same node. This results in Non-Uniform Memory Access (NUMA) across the system. The longer access times to other nodes can degrade software performance. The operating system attempts to limit degradation by scheduling threads from the same process on processors that are in the same node, and allocating all memory requests within the same node as the processor making the request. In addition, an API is included to make NUMA architecture information available to application software. These features ensure that memory accesses are local to a node wherever possible, and limit software degradation caused by the NUMA architecture. |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | Datacenter Program
The Datacenter Program provides customers with an integrated hardware, software, and service offering, delivered by Microsoft and qualified server vendors such as original equipment manufacturers (OEMs). |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | 2-GB RAM Maximum
RAM facilitates improved system scalability and performance. The more RAM added to a server beyond minimum requirements, the more memory available for applications to use. Designed for building and hosting Web applications, Web pages, and XML Web services, Windows Server 2003, Web Edition supports new systems with up to 2 GB of RAM. |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | 4-GB RAM Maximum
RAM facilitates improved system scalability and performance. The more RAM added to a server beyond minimum requirements, the more memory available for applications to use. Designed for small organizations and departmental use, Windows Server 2003, Standard Edition supports new systems with up to 4 GB of RAM. |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | 32-GB RAM Maximum
RAM facilitates improved system scalability and performance. The more RAM added to a server beyond minimum requirements, the more memory available for applications to use. Designed for demanding enterprise applications, Windows Server 2003, Enterprise Edition supports new systems with up to 32 GB of RAM. |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | 64-GB RAM Maximum(4)
RAM facilitates improved system scalability and performance. The more RAM added to a server beyond minimum requirements, the more memory available for applications to use. Designed for mission-critical applications, the 32-bit version of Windows Server 2003, Datacenter Edition supports up to 64 GB of RAM on x86-based computers. The 64-bit version of Windows Server 2003, Enterprise Edition supports systems with up to 64 GB of RAM. |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | 512-GB RAM Maximum(5)
RAM facilitates improved system scalability and performance. The more RAM added to a server beyond minimum requirements, the more memory available for applications to use. The 64-bit version of Windows Server 2003, Datacenter Edition supports systems with up to 512 GB of RAM. |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | 2-Way Symmetric Multiprocessing
The Windows Server 2003 family supports single or multiple CPUs that conform to the symmetric multiprocessing (SMP) standard. Using SMP, the operating system can run threads on any available processor, which makes it possible for applications to use multiple processors when additional processing power is required to increase the capability of a system. New features include SMP locking performance, improved registry performance, and increased Terminal Server sessions. Designed for building and hosting Web applications, Web pages, and XML Web services, Windows Server 2003, Web Edition supports new systems with up to two-way SMP. |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | 4-Way Symmetric Multiprocessing
The Windows Server 2003 family supports single or multiple CPUs that conform to the symmetric multiprocessing (SMP) standard. Using SMP, the operating system can run threads on any available processor, which makes it possible for applications to use multiple processors when additional processing power is required to increase the capability of a system. New features include SMP locking performance, improved registry performance, and increased Terminal Server sessions. Designed for small organizations and departmental use, Windows Server 2003, Standard Edition supports new systems with up to four-way SMP. |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | 8-Way Symmetric Multiprocessing
The Windows Server 2003 family supports single or multiple CPUs that conform to the symmetric multiprocessing (SMP) standard. Using SMP, the operating system can run threads on any available processor, which makes it possible for applications to use multiple processors when additional processing power is required to increase the capability of a system. New features include SMP locking performance, improved registry performance, and increased Terminal Server sessions. Designed for demanding enterprise applications, Windows Server 2003, Enterprise Edition supports new systems with up to eight-way SMP. This includes the 64-bit edition of Windows Server 2003, Enterprise Edition. |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | 32-Way Symmetric Multiprocessing
The Windows Server 2003 family supports single or multiple CPUs that conform to the symmetric multiprocessing (SMP) standard. Using SMP, the operating system can run threads on any available processor, which makes it possible for applications to use multiple processors when additional processing power is required to increase the capability of a system. New features include SMP locking performance, improved registry performance, and increased Terminal Server sessions. Designed for mission-critical applications, Windows Server 2003, Datacenter Edition supports new systems with 8-way to 32-way SMP. This includes the 64-bit edition of Windows Server 2003, Datacenter Edition. |
![]() |
![]() |
![]() |
![]() |
| Hardware Specifications | 64-Way Symmetric Multiprocessing
The Windows Server 2003 family supports single or multiple CPUs that conform to the symmetric multiprocessing (SMP) standard. Using SMP, the operating system can run threads on any available processor, which makes it possible for applications to use multiple processors when additional processing power is required to increase the capability of a system. New features include SMP locking performance, improved registry performance, and increased Terminal Server sessions. Designed for mission-critical applications, Windows Server 2003, Datacenter Edition supports new systems with up to 64-way SMP. The support for over 32 processors is only available with the 64-bit edition of Windows Server 2003, Datacenter Edition. Microsoft also offers a 128-way SKU for Windows Server 2003, Datacenter Edition so Windows can run on a 128-processor computer. However, the largest partition supported would be 64 processors. |
![]() |
![]() |
![]() |
![]() |
| Directory Services | Active Directory® Directory Service
Active Directory is the directory service for Windows Server 2003, Standard Edition; Windows Server 2003, Enterprise Edition; and Windows Server 2003, Datacenter Edition. It stores information about objects on the network and makes this information easy for administrators and users to find and use. Active Directory uses a structured data store as the basis for a logical, hierarchical organization of directory information. |
![]() |
![]() |
![]() |
![]() |
| Directory Services | Microsoft Identity Integration Server Support
Microsoft Identity Integration Server (MIIS) is a centralized service that stores and integrates identity information from multiple directories in an organization. The goal of this metadirectory is to provide an organization with a unified view of all known identity information about users, applications, and network resources. A metadirectory solves important business issues that result from having information stored in multiple, disparate data repositories throughout an organization. MIIS is available via Microsoft Consulting Services (MCS) or via an MIIS partner engagement. |
![]() |
![]() |
![]() |
![]() |
| Security Services | Internet Connection Firewall
Internet Connection Firewall (ICF) provides Internet security in the form of a firewall. Designed for use in the home and small business, ICF provides protection on computers directly connected to the Internet. This feature is available for LAN or dial-up networks, virtual private networks (VPNs), and Point-to-Point Protocol over Ethernet (PPPoE) connections. It also prevents scanning of ports and resources (such as file and printer shares) from external sources. |
![]() |
![]() |
![]() |
![]() |
| Security Services | Public Key Infrastructure, Certificate Services, and Smart Cards
By using Certificate Services and certificate management tools, you can deploy your own public key infrastructure (PKI). With a PKI, you can implement standards-based technologies, such as smart card logon capabilities, client authentication through Secure Sockets Layer (SSL) and Transport Layer Security (TLS), secure e-mail, digital signatures, and secure connectivity using Internet Protocol security (IPSec). By using Certificate Services, you can set up and manage certification authorities (CAs) that issue and revoke X.509 v3 certificates. This means that you do not have to depend on commercial client authentication services, although you can integrate commercial client authentication into your PKI if you choose. |
![]() |
![]() |
![]() |
![]() |
| Terminal Services | Remote Desktop for Administration
With Remote Desktop for Administration (formerly known as Terminal Services in Remote Administration mode), you can administer a computer from virtually any computer on your network. Based on Terminal Services technology, Remote Desktop for Administration is specifically designed for server management. |
![]() |
![]() |
![]() |
![]() |
| Terminal Services | Terminal Server
Terminal Server lets you deliver Windows-based applications — or the Windows desktop itself — to virtually any computing device, including those that cannot run Windows. For example, a user can access a virtual Windows XP Professional desktop and x86-based Windows applications from hardware that cannot run the software locally. Terminal Server provides this capability for both Windows-based and non–Windows-based client devices. When a user runs an application on Terminal Server, all of the application execution takes place on the server, and only keyboard, mouse, and display information traverses the network. Note
|
![]() |
![]() |
![]() |
![]() |
| Terminal Services | Terminal Server Session Directory
Terminal Server Session Directory allows users to easily reconnect to a disconnected session in a load-balanced Terminal Server farm. Session Directory is compatible with the Windows Server 2003 Network Load Balancing service, and is supported by third-party external load-balancer products from manufacturers such as F5 Networks (formerly F5 Labs) and Radware. Note
|
![]() |
![]() |
![]() |
![]() |
| Clustering Technologies | Network Load Balancing
Previously known as Windows NT Load Balancing Service (WLBS), Network Load Balancing distributes incoming TCP/IP traffic among multiple servers. Your clustered applications, especially Web server applications, can handle more traffic, provide higher availability, and provide faster response times. |
![]() |
![]() |
![]() |
![]() |
| Clustering Technologies | Cluster Service
A cluster is a group of independent computers, called nodes, that work together to run a common set of applications and provide high availability. If one node on the cluster fails, the application can be failed over to the next node. Server clusters of up to eight nodes are available only in Windows Server 2003, Enterprise Edition and Windows Server 2003, Datacenter Edition. |
![]() |
![]() |
![]() |
![]() |
| Communications and Networking Services | Virtual Private Network Support
You can give users ready access to your organization’s network even when they are out of the office — and reduce the cost of this access — by implementing a virtual private network (VPN). The VPN connection creates a secure tunnel across the Internet into the private network. There are two types of VPN technologies in the Windows Server 2003 family: Point-to-Point Tunneling Protocol (PPTP), which employs user-level Point-to-Point Protocol (PPP) authentication methods and Microsoft Point-to-Point Encryption (MPEE) for data encryption; and Layer Two Tunneling Protocol (L2TP) with Internet Protocol security (IPSec). L2TP employs user-level PPP authentication methods and computer-level certificates with IPSec for data encryption. On Windows Server 2003, Web Edition and Windows Server 2003, Standard Edition, you can create up to 100 PPTP ports and up to 100 L2TP ports. However, Windows Server 2003, Web Edition, can accept only one VPN connection at a time. Windows Server 2003, Standard Edition, can accept up to 1,000 concurrent VPN connections via the ports. If 1,000 VPN clients are connected, further connection attempts are denied until the number of connections falls below 1,000. Windows Server 2003, Enterprise Edition and Windows Server 2003, Datacenter Edition support unlimited concurrent users. |
![]() |
![]() |
![]() |
![]() |
| Communications and Networking Services | Internet Authentication Service
Internet Authentication Service (IAS) is the Microsoft implementation of a Remote Authentication Dial-in User Service (RADIUS) server and proxy. As a RADIUS server, IAS performs centralized connection authentication, authorization, and accounting for many types of network access including wireless, authenticating switch, and remote access dial-up and virtual private network (VPN) connections. As a RADIUS proxy, IAS forwards authentication and accounting messages to other RADIUS servers. You can configure IAS in Windows Server 2003, Standard Edition, with a maximum of 50 RADIUS clients and a maximum of 2 remote RADIUS server groups. With IAS in Windows Server 2003, Enterprise Edition, and Windows Server 2003, Datacenter Edition, you can configure an unlimited number of RADIUS clients and remote RADIUS server groups. In addition, you can configure RADIUS clients by specifying an IP address range. |
![]() |
![]() |
![]() |
![]() |
| Communications and Networking Services | Network Bridge
Network Bridge provides an easy way for you to connect different LAN segments, allowing users to bridge connections between different computers and devices on their network, even when they connect to the network through different methods. Network bridge is supported in Windows Server 2003, Standard Edition and Windows Server 2003, Enterprise Edition. |
![]() |
![]() |
![]() |
![]() |
| Communications and Networking Services | Internet Connection Sharing
By using the Internet Connection Sharing (ICS) feature of Network Connections, you can connect your home network or small office network to the Internet. For example, you might have a home network that connects to the Internet through a dial-up connection. By enabling ICS on the computer that uses the dial-up connection, you can provide network address translation (NAT), addressing, and name resolution services for all the computers on your network. |
![]() |
![]() |
![]() |
![]() |
| Communications and Networking Services | IPv6
Internet Protocol version 6 (IPv6) is a suite of Internet standard protocols that will become the next generation of network layer protocols for the Internet. IPv6 is designed to solve many of the problems of the current version of IP (known as IPv4) with regard to address depletion, security, autoconfiguration, extensibility, and more. |
![]() |
![]() |
![]() |
![]() |
| File and Print Services | Distributed File System
Distributed File System (DFS) is enhanced for Windows Server 2003, Enterprise Edition and Windows Server 2003, Datacenter Edition by allowing multiple DFS roots on a single server. You can use this feature to host multiple DFS roots on a single server, reducing administrative and hardware costs of managing multiple namespaces and multiple replicated namespaces. Using Active Directory, DFS shares can be published as volume objects and administration can be delegated. Windows Server 2003, Standard Edition supports only one DFS root. DFS is partially supported in Windows Server 2003, Web Edition, where it is possible to access DFS files and act as a node in DFS tree, but only 10 concurrent incoming server message block (SMB) connections are permitted. |
![]() |
![]() |
![]() |
![]() |
| File and Print Services | Encrypting File System
Encrypting File System (EFS) complements other access controls and provides an additional level of protection for your data. EFS runs as an integrated system service on all disks (including clustered disks), making it easy to manage, difficult to attack, and transparent to the user. |
![]() |
![]() |
![]() |
![]() |
| File and Print Services | Shadow Copies for Shared Folders
Shadow Copy Restore (Previous Versions) provides point-in-time copies for network folders. Users can easily access previous versions of their files through Windows Explorer by right-clicking a file or folder. |
![]() |
![]() |
![]() |
![]() |
| File and Print Services | Removable Storage
Removable Storage makes it easy to track your removable storage media (tapes and optical discs) and to manage the hardware libraries (such as changers and jukeboxes) that contain them. Because removable optical discs and tapes are less expensive per megabyte than hard disks, Removable Storage and Remote Storage can decrease your costs. |
![]() |
![]() |
![]() |
![]() |
| File and Print Services | Remote Storage
Remote Storage uses criteria that you specify to automatically copy little-used files to removable media. If hard disk space drops below specified levels, Remote Storage removes the cached file content from the disk. If the file is needed later, the content is automatically recalled from storage. Remote Storage now supports migration to magneto-optical media. Remote Storage is not available in Windows Server 2003, Standard Edition or Windows Server 2003, Web Edition. |
![]() |
![]() |
![]() |
![]() |
| File and Print Services | Fax Service
Fax Service lets users send and receive faxes by using a modem or a fax board. You can also send faxes by using your network. You can print to fax from any application, send a cover page, and track and monitor fax activity. New wizards simplify configuration and fax sending. Also, developers can write applications using the new fax APIs to automatically send faxes from their applications. |
![]() |
![]() |
![]() |
![]() |
| File and Print Services | Services for Macintosh
Services for Macintosh provides Macintosh users with access to files stored on a computer running Windows Server 2003. The file server is accessible over TCP/IP networks and over AppleTalk networks. Print services allow Macintosh clients to print to Windows NT or Windows 2000–based print shares via the AppleTalk protocol. In addition to the print server, there is a 300 dpi PostScript RIP engine that allows Macintosh-generated PostScript print jobs to be sent to non-PostScript printers, such as inkjet printers. |
![]() |
![]() |
![]() |
![]() |
| Management Services | IntelliMirror® Management Technologies
To help reduce costs, administrators need high levels of control over portable and desktop systems. IntelliMirror management technologies provide this control on client systems running Windows 2000 Professional or Windows XP Professional. You can use IntelliMirror to define policies based on business roles, group memberships, and locations. With these policies, Windows 2000 Professional desktops and Windows XP Professional desktops are automatically reconfigured to meet a specific user’s requirements each time that user logs on to the network, regardless of where the user logs on. |
![]() |
![]() |
![]() |
![]() |
| Management Services | Group Policy Results
Group Policy Results allows administrators to see the effect a Group Policy setting has on a targeted user or computer. Included in the Group Policy Management Console, Group Policy Results provides administrators with a powerful and flexible base-level tool to plan, monitor, and troubleshoot Group Policy. Group Policy Results uses Windows Management Instrumentation (WMI), making the information available to administrators via the console and directly to other management applications via WMI. |
![]() |
![]() |
![]() |
![]() |
| Management Services | Windows Management Instrumentation Command Line
Windows Management Instrumentation (WMI) provides unified access to the management functions of local and remote systems. By adding command-line access to WMI, administrators can directly access these management functions and create queries based on this data. You can monitor local and remote Windows Server 2003 and Windows XP systems directly, to view results through the command line or to retrieve the management data in XML format and processed into built-in or custom XSL output formats. WMI follows the specifications of the industry-standard Common Information Model (CIM) defined by the Distributed Management Task Force (DMTF). |
![]() |
![]() |
![]() |
![]() |
| Management Services | Remote OS Installation
Remote OS Installation uses Group Policy, Remote Installation Services, and Pre-Boot eXecution Environment (PXE) server hardware to re-image a server with a clean install of a Windows Server 2003–based environment. This feature can also be used to re-image Windows 2000 and Windows XP desktops. Administrators can use Remote OS Installation and IntelliMirror together to simplify the task of exchanging or bringing new computers into the network environment:
Used together with IntelliMirror or on its own, Remote OS Installation can increase the efficiency of computer management in your organization while simplifying the task of maintaining corporate-standard environments on Windows-based servers and desktops. |
![]() |
![]() |
![]() |
![]() |
| Management Services | Remote Installation Services
You can use Remote Installation Services (RIS) to create automated installation images of operating systems or of complete computer configurations. You can then make these installation images available to users at client computers. You can also specify which RIS server will provide installations to a given client computer. The client computers must support remote booting with the Pre-Boot eXecution Environment (PXE) ROM, or they must be started with a remote-startup floppy disk. |
![]() |
![]() |
![]() |
![]() |
| Management Services | Windows System Resource Manager
Windows System Resource Manager (WSRM) provides resource management and enables the allocation of resources, including processor and memory resources, among multiple processes based on business priorities. An administrator sets targets for the amount of hardware resources that running applications or users (typically in a Terminal Server environment) are allowed to consume. It also creates utilization accounting records for management, service level agreement (SLA) tracking, and enabling charge-backs. |
![]() |
![]() |
![]() |
![]() |
| .NET Application Services | .NET Framework(2)
The .NET Framework enables your developers to create great Web applications with the help of ASP.NET and other technologies. It also helps them build the same type of applications they design and develop today. The .NET Framework is language-neutral; virtually any programming language can target it. Developers can build .NET-based applications and services in a number of languages, including Visual C++, Visual Basic .NET, JScript, and Visual C#. Integrated into the Windows Server 2003 family, the .NET Framework is the infrastructure for .NET. The .NET Framework incorporates the common language runtime and a unified set of class libraries that include Windows Forms, ADO.NET, ASP.NET, and other capabilities. The .NET Framework provides a fully managed, protected, and feature-rich application execution environment, simplified development and deployment, and seamless integration with a wide variety of programming languages. |
![]() |
![]() |
![]() |
![]() |
| .NET Application Services | Internet Information Services 6.0
Internet Information Services (IIS) 6.0 is a full-featured Web server that provides the foundation for the Windows Server 2003 family and existing Web-based applications and XML Web services. IIS 6.0 offers dedicated application mode, which runs all application code in an isolated environment. IIS 6.0 also supports Web gardens, in which a set of equivalent processes on a computer each receive a share of the requests normally served by a single process, achieving better multiprocessor scalability. |
![]() |
![]() |
![]() |
![]() |
| .NET Application Services | ASP.NET(2)
ASP.NET is the engine for Web-based applications and XML Web services. It brings rapid application development to the server. Part of the class library in the .NET Framework, ASP.NET pages use a compiled, event-driven programming model that improves performance and enables the separation of application logic and user interface. |
![]() |
![]() |
![]() |
![]() |
| .NET Application Services | Enterprise UDDI Services
Universal Description, Discovery, and Integration (UDDI) is an industry specification for publishing and locating information about Web services. Some products in the Windows Server 2003 family include UDDI Services, a Web service that provides UDDI capabilities for use within an enterprise or across organizations. UDDI Services is not included with Windows Server 2003, Web Edition. In addition, Windows Server 2003, Standard Edition, supports only stand-alone installations of UDDI Services. Distributed installation support is available with Windows Server 2003, Enterprise Edition and Windows Server 2003, Datacenter Edition. In a stand-alone installation of UDDI Services, both the UDDI Web server component and the UDDI database component are installed on a single server. In a distributed installation, UDDI components are distributed across multiple servers. |
![]() |
![]() |
![]() |
![]() |
| Multimedia Services | Windows Media® Services
Windows Media Services provide streaming audio and video over corporate intranets and the Internet. In Windows Server 2003, Enterprise Edition and Windows Server 2003, Datacenter Edition, Windows Media Services delivers advanced streaming functionality such as multicasting, wireless network support, Internet authentication, server plug-ins, and cache/proxy APIs. |
![]() |
![]() |
![]() |
![]() |
Yahoo! Messenger Archive Location
by John on Feb.23, 2010, under Software, TIPS, Troubleshooting
Yahoo! Messenger Archive Location
Update: This tip also applies if you want to find Yahoo! Messenger’s archive location in Windows 7.
Backing up Yahoo! Messenger’s message archive is a task I do every so often. Since I switched to Vista, I’ve been unable to figure out where the log files have gone. Surely, It’s no longer under Y!M’s installation directory.
In Windows XP, the location of the log files (.dat) is typically as follows, unless the installation directory was changed:
C:\Program Files\Yahoo!\Messenger\Profiles\<yahoo_username>
In Windows Vista, the new location of the log files have been moved to the user’s AppData directory:
C:\Users\<windows_usrnme>\AppData\Local\VirtualStore\Program Files\Yahoo!\Messenger\Profiles\<yahoo_username>
C:\Users\<windows_usrnme>\AppData\Local\VirtualStore\Program Files (x86)\Yahoo!\Messenger\Profiles\<yahoo_username> (for x86 version of Windows)
Accessing this folder is another story, however. From my experience, navigating to the directory crashes Windows Explorer. To access the directory, just copy and paste the Profiles folder path shown above into Windows Explorer’s address bar. Change <windows_usrnme> and <yahoo_username> as necessary.
Date Formulas and Functions in Microsoft Excel
by John on Feb.21, 2010, under Excel, Software
Date Formulas and Functions in Microsoft Excel
Excel stores dates in sequential serial numbers beginning with January 1st, 1900 as 1. January 1st, 2006 is 38718 because it’s 38,718 days after January 1st, 1900. Excel on MAC works the same, except the dates start on January 1st, 1904. Don’t ask me why.
Note: There are several different ways to do everything in Microsoft Office applications. Date formulas and functions are no different, so this list isn’t comprehensive, but should get you by until you become an expert.
Note: Some of these formulas and functions require use of the Analysis Toolpak Addin. Just go to ToolsàAddins, and put a check next to Analysis Toolpak if you get a #NAME? error.
Note: Some of these formulas and functions use a named range called “Holidays”. To create it, make a list of dates in a column. Assign the named range to the cells.
Tip: Volatile formulas are formulas that recalculate every time the workbook calculates. The =NOW formula (among others) is a Volatile formula. If you open a workbook that contains a volatile formula, you make no changes, and close it, don’t be surprised if you’re asked to save the workbook. That’s because the value that the recalculation created did, in fact, change in your workbook.
Date Formulas and Functions
- Today’s date and time:
=NOW()
- Today’s date only:
=TODAY()
- Day of the month for a specific date:
=DAY(TODAY())
- Day of the week for a specific date (set the cell format to custom format “dddd”):
=WEEKDAY(TODAY())
=TEXT(WEEKDAY(TODAY()),”dddd”)
- Month of the year for a specific date:
=MONTH(TODAY())
- Year for a specific date:
=YEAR(TODAY())
- Date for a specific year, month and day (Example returns 6/12/2005):
=DATE(2005,6,12)
- Add days to a date (one week from today):
=TODAY()+7
- Subtract days from a date (one week ago today):
=TODAY()-7
- Last day of the this month:
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1
or
=EOMONTH(TODAY(),0)
- Last workday of the current month:
=IF(WEEKDAY(EOMONTH(TODAY(),0))=6,EOMONTH(TODAY(),0)-1,IF(WEEKDAY(EOMONTH(TODAY(),0))=1,EOMONTH(TODAY(),0)-2,EOMONTH(TODAY(),0)))
or
=WORKDAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),-1,Holidays)
- First workday of the following month:
=WORKDAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1,1,Holidays)
- Number of workdays in the current month:
=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(TODAY()),1),EOMONTH(TODAY(),0),Holidays)
- Last workday in range of days (A1 is start date, B1 is number of days in the period):
=WORKDAYS(A1,B1,Holidays)
DATEDIF() Syntax & Examples
The DATEDIF() function uses the following syntax:
=DATEDIF(start_date,end_date,”code”)
The start date must be less than the end date, or the function returns an error.
The following are the codes for the DATEDIF() function:
- “y” Years
- “m” Months
- “d” Days
- “md” Difference between days in a period; no month and years
- “ym” Difference between the months in a period, no days and years
- “yd” Difference between the days in a period, no years
Examples
- To calculate the number of years between two dates:
=DATEDIF(A1,TODAY(),”y”) & ” Years”
- To calculate the number of years and months between two dates:
=DATEDIF(A1,TODAY(),”y”) & ” Years, ” & DATEDIF(A1,TODAY(),”ym”) & ” Months”
- To calculate the number of years, months, and days between two dates:
=DATEDIF(A1,TODAY(),”y”) & ” Years, ” & DATEDIF(A1,TODAY(),”ym”) & ” Months, ” & DATEDIF(A1,TODAY(),”md”) & ” Days”
Using the TEXT() function to calculate dates.
You can use the TEXT() to get the number of days or weeks between two dates:
Examples
- Number of days:
=VALUE(TEXT((NOW()-$A$1)/24,”[h]“))
- Number of weeks:
=VALUE(TEXT((NOW()-$A$1)/168,”[h]“))
Formula to calculate the difference in weeks between two dates
by John on Feb.21, 2010, under Excel, Software
=INT((MAX(A1:A10)-MIN(A1:A10))/7)
or if you want the odd days as well:
=INT((MAX(A1:A10)-MIN(A1:A10))/7)&” Weeks & ”
&MOD((MAX(A1:A10)-MIN(A1:A10)),7)&” Days”
Courtesy of ExcelIsFun’s Channel
http://flightline.highline.edu/mgirvin/excelisfun.htm
http://www.youtube.com/user/ExcelIsFun#p/search/25/uoED6-YF7dE
Combine 2 Text from 2 cells in One Cell
by John on Feb.21, 2010, under Excel, Software
|
COURSE TEXT
In this example, a text file has been imported into Excel. First names and last names are in two separate columns. To combine the information into one cell, you would use a formula that is unlike what you’ve seen before. It uses the ampersand (&) operator instead of a function. You would type this formula in cell C2: =A2&” “&B2 The ampersand tells Excel to combine the text from cell A2, and a space (identified by the quotation marks around it), and the text from cell B2. To combine the other names into other cells in column C, you would copy the formula down the column. Note You can do the same operation by using the CONCATENATE function: =CONCATENATE(A2,” “,B2), but it’s faster to just type the ampersand. “Concatenate” means to combine, by the way, or had you guessed? |
Combine two text cells in One – EXCEL
by John on Feb.21, 2010, under Excel, Software
In this example, a text file has been imported into Excel. First names and last names are in two separate columns. To combine the information into one cell, you would use a formula that is unlike what you’ve seen before. It uses the ampersand (&) operator instead of a function. You would type this formula in cell C2:
=A2&” “&B2
The ampersand tells Excel to combine the text from cell A2, and a space (identified by the quotation marks around it), and the text from cell B2.
To combine the other names into other cells in column C, you would copy the formula down the column.
Note You can do the same operation by using the CONCATENATE function: =CONCATENATE(A2,” “,B2), but it’s faster to just type the ampersand. “Concatenate” means to combine, by the way, or had you guessed?
Process Monitor V2.04
by John on Feb.21, 2010, under Software, TIPS, Troubleshooting
Process Monitor v2.04
Published: March 17, 2009
Introduction
Process Monitor is an advanced monitoring tool for Windows that shows real-time file system, Registry and process/thread activity. It combines the features of two legacy Sysinternals utilities, Filemon and Regmon, and adds an extensive list of enhancements including rich and non-destructive filtering, comprehensive event properties such session IDs and user names, reliable process information, full thread stacks with integrated symbol support for each operation, simultaneous logging to a file, and much more. Its uniquely powerful features will make Process Monitor a core utility in your system troubleshooting and malware hunting toolkit.
Process Monitor Enhancements over Filemon and Regmon
Process Monitor’s user interface and options are similar to those of Filemon and Regmon, but it was written from the ground up and includes numerous significant enhancements, such as:
Monitoring of process and thread startup and exit, including exit status codes
Monitoring of image (DLL and kernel-mode device driver) loads
More data captured for operation input and output parameters
Non-destructive filters allow you to set filters without losing data
Capture of thread stacks for each operation make it possible in many cases to identify the root cause of an operation
Reliable capture of process details, including image path, command line, user and session ID
Configurable and moveable columns for any event property
Filters can be set for any data field, including fields not configured as columns
Advanced logging architecture scales to tens of millions of captured events and gigabytes of log data
Process tree tool shows relationship of all processes referenced in a trace
Native log format preserves all data for loading in a different Process Monitor instance
Process tooltip for easy viewing of process image information
Detail tooltip allows convenient access to formatted data that doesn’t fit in the column
Cancellable search
Boot time logging of all operations
The best way to become familiar with Process Monitor’s features is to read through the help file and then visit each of its menu items and options on a live system.

Reset and Restart the Services in Vista
by John on Feb.20, 2010, under Operating System, TIPS, Troubleshooting
Event Log stopped working – Error 1747 : The Authentication Service is Unknown
open a command prompt with administrative rights and run
netsh winsock reset
Restart the computer
Como Instalar Programas en Linux
by John on Feb.20, 2010, under LINUX, Software
Cómo instalar programas en Linux desde su código fuente
Los usuarios de Windows están acostumbrados a instalar programas con archivos ejecutables o .EXE. En Linux, en cambio, hay variedad de instaladores según la distribución que uses, como DEB, RPM, BIN o TAR.
En Softonic acostumbramos a ofreceros el código fuente de las aplicaciones para que podáis instalarlo en cualquier distribución Linux y para que tengáis la versión más actual. Sin embargo, instalar un programa a partir del código fuente no es tarea fácil.
En esta guía aprenderemos a compilar el código fuente de un programa Linux cualquiera.
Antes de empezar, ¿qué es código fuente? El código fuente es el programa tal como lo escribió el programador. De esta forma podemos editarlo y adaptar la aplicación a sus necesidades. Por otra parte, permite instalarlo en diferentes sistemas operativos, o en este caso, cualquier distribución Linux.
Sin embargo, el ordenador no entiende este código fuente, así que tendremos que compilarlo usando el terminal.

Descomprimir el código fuente
En primer lugar, y una vez hayamos conseguido el código fuente desde Softonic, hay que extraerlo del archivo comprimido en el que suele venir, ya sea ZIP, RAR o los más habituales, TAR.GZ y TAR.BZ2. Aunque las distribuciones más usadas descomprimen con aplicaciones gráficas, desde el terminal descomprimiremos estos archivos con los siguientes comandos:
- Acabados en TAR.GZ. Teclea tar -xvzf y su nombre con la extensión.
- Acabados en TAR.BZ2. Teclea tar -xvjf y su nombre con la extensión.
- Acabados en TAR.BZ. Teclea tar -xvif y su nombre con la extensión.
- Acabados en RAR. Teclea unrar e -kb y su nombre con la extensión.
- Acabados en ZIP. Teclea unzip y su nombre con la extensión.
Por ejemplo, tar -xvjf brasero-0.7.0.tar.bz2
Resolver las dependencias
Estos comandos crean una carpeta con el código fuente, donde tendremos en cuenta los siguientes archivos: README e INSTALL. En uno de los dos encontraremos qué dependencias requiere el programa y qué comandos teclear en el terminal para compilarlo.

El primer dato es fundamental, ya que las dependencias son los paquetes que utiliza el programa que vamos a instalar para funcionar.
Las dependencias pueden ser librerías de lenguajes de programación, como Python, Perl o C++. Otras serán necesarias simplemente para compilar el código, como make, cmake o gcc. También las hay que forman parte de nuestro Entorno de Escritorio, KDE o Gnome. Y otras, simplemente, son librerías que realizan funciones por separado y en las que se apoya nuestro programa a compilar, como GTK (que usa GIMP) o gstreamer (para reproducir vídeos).
El principal problema viene cuando el autor del programa no nos da ninguna instrucción de qué dependencias requiere su creación. Por suerte, en algunos casos al intentar compilar veremos mensajes de error que, si nos fijamos bien, nos alertarán de que faltan ciertos paquetes.
Así pues, antes de compilar el código fuente del programa a instalar tendremos que satisfacer las dependencias. Podemos hacerlo desde el gestor de paquetes de nuestra distribución, como Synaptic en Debian/Ubuntu o Yum en Fedora.
Instalar el programa
Desde terminal dependerá de la distribución que usemos. En Ubuntu/Debian se puede usar la herramienta aptitude. Por ejemplo, el autor nos dice que su programa usa la librería GTK para Java, libgtk-java. Pues escribimos en el terminal:
>sudo aptitude install libgtk-java
Aptitude se encargará de buscar e instalar también las dependencias de este paquete. En caso de no saber el nombre concreto del paquete, podríamos buscar GTK y Java escribiendo:
>aptitude search gtk java

En Fedora y derivados, usaremos yum. Primero introducimos el comando su, para usar el terminal como root o superusuario. Para buscar paquetes, yum search, y para instalarlo yum install.
>yum search amsn
>su
>yum install amsn
Una vez resueltas las dependencias habrá terminado el trabajo duro. El resto es pan comido.
El proceso habitual suele consistir en:
>make
>sudo make install
Otras aplicaciones requieren pasos distintos. En lugar de make, pueden usar cmake o jam, y algunos, programados en Python, se instalan simplemente con el comando:
>sudo python setup.py install
Espero que estas sencillas instrucciones os hayan sido útiles ahorrándoos quebraderos de cabeza. ¡Buena suerte!
nLite – Software to change or Create Drivers for SATA HDD
by John on Feb.20, 2010, under Operating System, Software, TIPS, Troubleshooting
We come through a lot of problems in installing our own Operating Systems in our laptops, like “Setup did not find any hard disk drives installed in your computer”, etc. Here I have given a solution that will definitely solve these problems. Here we create our own Windows installation CD/DVD which will include all the drivers, etc. we want like the SATA driver. We have already seen one solution to this problem which uses the BIOS facility to activate the installation. The solution was a simple one but it is not ideal for some laptops.
We have to use software known as nLite to perform the driver integration operation. To download the software click here. For Downloading Intel SATA AHCI Drivers for Windows XP Click here. After successfully installing the software(nLite) follow the steps given below:
Step 1: Copy your Windows installation disc into some folder in your hard drive. Here I named my folder as WINXP.
Step 2: Open nLite. Click Next.
Step 3: Now Click Browse. Select the folder where you have copied your Windows installation Disc. Click OK.
Step 4: It will show the details of your installation. Click Next.
Step 5: As we don’t have any Presets click next.
Step 6: Here it will show the activities you want to perform. Select Drivers in Integrate section and Bootable ISO in Create section. Click Next.
Step 7: Now click insert and select multiple driver option.
Step 8: You can browse and select the driver folder you want to integrate. Select All and OK.
Step 9: It will show you the details of the driver. Select All and Click Ok. After that cllick next. It will ask for confirmation. Click Yes.
Step 10: After it completes the integration process click next.
Step 11: Now you can burn your disc. Select direct burn.
Step 12: Click Burn. Confirm Yes.
tep 13: Wait until it finishes. Click Finish.
Now you have successfully completed integrating the driver. You can use this CD for installation in any laptop where the SATA native is not supported.
You can use nLite for any purpose like integrating components, etc.
You can download the Intel SATA AHCI drivers from:
Download Intel SATA AHCI Drivers for Windows XP
