Teri

Posts: n/a

Thanks Jason--Worked great.

"Jason Morin" wrote:

=COUNTIF(D2:D25,"<"&TODAY())

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a column that I would like to have a count of all
the dates that are
less then today's date.

I have tried: =countif(d2:d25,"<TODAY",0) This has only
gotten me 0. If I
leave the " " out then I get an error message. What do I
need to do?

Thanks in Advance.
.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Formating Dates for production schedule	dpl7579	Excel Discussion (Misc queries)	1	January 11th 05 08:43 PM
Counting Dates?	Aviator	Excel Discussion (Misc queries)	3	January 10th 05 08:05 PM
due dates	Niki	New Users to Excel	4	January 10th 05 04:11 PM
Counting columns and specific Dates	JulieD	Excel Worksheet Functions	2	November 12th 04 01:13 PM
counting entries between two dates?	Todd	Excel Worksheet Functions	7	November 1st 04 11:07 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us