» Counting Date Values by Specified Date Criteria
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
Problem: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:
- Guide to Financial Reporting and Analysis
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Windows XP All-in-One Desk Reference For Dummies
- Financial Statement Analysis with S&P insert card
No comments have been submitted.
