» Avoiding False Results when Counting Dates Matching Specified Criteria
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Column A contains dates formatted as "mm/dd/yyyy".
When using the following COUNTIF formula to count the number of dates after April 1st, 2005:
=COUNTIF(A2:A6,">"&--"04/01/05")
A false result of 4 was returned.
Solution 1:
To avoid any format related problems, use the COUNTIF and DATE functions as shown in the following formula:
=COUNTIF(A2:A6,">"&DATE(2005,4,1))
Solution 2:
Use the COUNTIF function as shown in the following formula:
=COUNTIF(A2:A6,">"&--"2005-04-01")
Book Store:
Recommended Books:
- The Interpretation of Financial Statements
- Writing Excel Macros with VBA, 2nd Edition
- Accounting for Dummies
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Windows XP All-in-One Desk Reference For Dummies
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
