Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 27th 06, 06:27 PM posted to microsoft.public.excel.newusers
Cachod1
 
Posts: n/a
Default count the number of cells with a date <= today's date

I need to count the number of cells in a column that contain a date that is
<= today's date. I've tried using a COUNTIF formula but it's not working.
HELP!

  #2   Report Post  
Old January 27th 06, 06:33 PM posted to microsoft.public.excel.newusers
JMB
 
Posts: n/a
Default count the number of cells with a date <= today's date

If the data is in cells A1:A3

=COUNTIF(A1:A3, "<="&TODAY())

"Cachod1" wrote:

I need to count the number of cells in a column that contain a date that is
<= today's date. I've tried using a COUNTIF formula but it's not working.
HELP!

  #3   Report Post  
Old January 27th 06, 07:32 PM posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default count the number of cells with a date <= today's date

This formula will also count any other number that is NOT a date, as though
it WAS a date............

Vaya con Dios,
Chuck, CABGx3



"JMB" wrote:

If the data is in cells A1:A3

=COUNTIF(A1:A3, "<="&TODAY())

"Cachod1" wrote:

I need to count the number of cells in a column that contain a date that is
<= today's date. I've tried using a COUNTIF formula but it's not working.
HELP!

  #4   Report Post  
Old January 27th 06, 09:14 PM posted to microsoft.public.excel.newusers
Bob Phillips
 
Posts: n/a
Default count the number of cells with a date <= today's date

=SUMPRODUCT(--(A2:A200<""),--(A2:A200<=TODAY()))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Cachod1" wrote in message
...
I need to count the number of cells in a column that contain a date that

is
<= today's date. I've tried using a COUNTIF formula but it's not working.
HELP!





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
How do I sum a range if the date is is greater than today's date? S2 Excel Worksheet Functions 4 October 8th 05 08:11 PM
how to count number of cells in a color ? Francisco Excel Discussion (Misc queries) 4 September 25th 05 01:09 PM
How do I count the number of cells in a list, e.g. H6:H12, J4, J7: KTS Excel Worksheet Functions 0 July 26th 05 08:09 PM
Count cells based on date range in another column [email protected] New Users to Excel 1 May 5th 05 08:11 PM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 08:35 PM


All times are GMT +1. The time now is 11:50 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017