» 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:
- The One Page Business Plan: Start With a Vision, Build a Company!
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Financial Peace: Revisited
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Microsoft Office XP Introductory Concepts and Techniques
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
No comments have been submitted.
