Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Cachod1
 
Posts: n/a
Default Count number of cells with date <today's date

I need to count the number of cells in one column that contain a date that is
<= today's date. The dates are currently formatted as "General" numbers
rather than being formatted as "Date"
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Umlas
 
Posts: n/a
Default Count number of cells with date <today's date

=COUNTIF(B1:B100,"<"&TODAY())
Bb Umlas
Excel MVP
"Cachod1" wrote in message
...
I need to count the number of cells in one column that contain a date that

is
<= today's date. The dates are currently formatted as "General" numbers
rather than being formatted as "Date"



  #3   Report Post  
Posted to microsoft.public.excel.newusers
JMB
 
Posts: n/a
Default Count number of cells with date <today's date

Which of the four responses you've received thus far don't work???????????

"Cachod1" wrote:

I need to count the number of cells in one column that contain a date that is
<= today's date. The dates are currently formatted as "General" numbers
rather than being formatted as "Date"

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
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 8 May 18th 05 04:23 AM
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 0 May 15th 05 08:14 PM
Seed date formats to different year in different cells KR Excel Discussion (Misc queries) 4 February 12th 05 01:02 AM
Can I count how many grey-filled cells are in a row ? AnthonyG Excel Worksheet Functions 1 February 4th 05 11:08 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 09:35 PM


All times are GMT +1. The time now is 12:05 PM.

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

About Us

"It's about Microsoft Excel"