Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 29th 05, 07:07 PM
Cachod1
 
Posts: n/a
Default Count cells in a column that contain dates

Column J contains dates in some cells, and text in others. I need to count
the number of cells in this one column that contains dates. How can I do
this?

  #2   Report Post  
Old March 29th 05, 08:56 PM
Dave Peterson
 
Posts: n/a
Default

If the only cells that are in that column that are numeric (like dates), you can
use:

=count(a:a)

(Dates are just numbers formatted nicely in excel.)

Cachod1 wrote:

Column J contains dates in some cells, and text in others. I need to count
the number of cells in this one column that contains dates. How can I do
this?


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula that will count between dates ranges jbsand1001 Excel Worksheet Functions 4 April 1st 05 11:41 PM
Counting the number cells between two dates Dave Excel Discussion (Misc queries) 3 March 16th 05 02:30 PM
Formula that will count between dates ranges jbsand1001 Excel Worksheet Functions 0 March 7th 05 06:41 PM
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. witchcat98 Excel Worksheet Functions 1 February 4th 05 01:38 PM
SUMPRODUCT Formula to Count Row of data Below Matched Criteria Sam via OfficeKB.com Excel Worksheet Functions 8 February 3rd 05 01:37 AM


All times are GMT +1. The time now is 06:09 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017