DeborahS

Posts: n/a

Count the number of dates in a range that are earlier than today.

I need a formula to count the number of dates in a range that are earlier
than today. I've been trying to use countif, but can't get it to use both
the less-than < sign and the volitile today() function. Thanks in advance
for any help.

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
Count number of occurences in 1 column only if something in anothe	Wenster	Excel Worksheet Functions	2	February 7th 05 09:58 PM
Count number to reach a cumulative value	Bruce	Excel Worksheet Functions	5	January 25th 05 05:14 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
I have a list of dates that I need to count based on a date range	ejb030353	Excel Worksheet Functions	4	November 24th 04 02:27 PM
Count occurences between dates	DJ Dusty	Excel Worksheet Functions	3	November 11th 04 12:25 AM

All times are GMT +1. The time now is 09:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us