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

I need to count the number of cells within a column that contain a date that
is less than/equal to today's date. What formula can I use to do this?

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

Try this:

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

HTH,
Elkar

"Cachod1" wrote:

I need to count the number of cells within a column that contain a date that
is less than/equal to today's date. What formula can I use to do this?

  #3   Report Post  
Old January 27th 06, 11:24 PM posted to microsoft.public.excel.newusers
Anne Troy
 
Posts: n/a
Default count the number of cells within a column with a date <= today's d

This is the 3rd time you have asked the same question. What is wrong with
the answers you're receiving?
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Cachod1" wrote in message
...
I need to count the number of cells within a column that contain a date
that
is less than/equal to today's date. What formula can I use to do this?





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
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
Count the number of Cells in one ROW with conditions Amanda Excel Worksheet Functions 2 September 9th 05 04:03 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
How do I count cells in a column of dates between date ranges? Andrew82 Excel Worksheet Functions 2 April 14th 05 09:59 AM
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 09:38 PM.

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