» Counting Date Values by Specified Date Criteria
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
Counting the number of dates in column A that are equal and later than 01/01/2005.
Solution:
Use the COUNTIF and DATE functions as shown in the following formula:
=COUNTIF(A2:A10,">="&DATE(2005,1,1))
Book Store:
Recommended Books:
- Microsoft Windows XP Registry Guide
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Special Edition Using Microsoft Office XP
- Keys to Reading an Annual Report (Barron's Business Keys)
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- The New Financial Order: Risk in the Twenty-First Century
No comments have been submitted.
