Remember Me?

#1
January 27th 06, 11:59 PM posted to microsoft.public.excel.newusers
 Cachod1 Posts: n/a
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
January 28th 06, 12:23 AM posted to microsoft.public.excel.newusers
 Elkar Posts: n/a
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
January 28th 06, 12:24 AM posted to microsoft.public.excel.newusers
 Anne Troy Posts: n/a
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
************
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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 07:16 PM Amanda Excel Worksheet Functions 2 September 9th 05 04:03 PM baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM Andrew82 Excel Worksheet Functions 2 April 14th 05 09:59 AM Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 09:35 PM

All times are GMT +1. The time now is 07:30 AM.