Posted to microsoft.public.excel.misc

external usenet poster

Posts: 972

=COUNTIF formula

I have a cloumn of dates and want to enter a formula that will tell how dates
are older than today. I tried =COUNTIF(F11:F369, "<TODAY()") with no sucess.
The best I could get was using the formula and instead of TODAY() I used
1/15/2010.

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
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED	Debbi	Excel Worksheet Functions	2	November 18th 09 04:47 AM
CountIf formula	Verne	Excel Discussion (Misc queries)	4	November 8th 09 11:09 PM
Formula Help (countif, I think....)	RUSH2CROCHET	Excel Discussion (Misc queries)	2	June 6th 08 10:14 PM
countif formula	archivesgirl	Excel Discussion (Misc queries)	3	February 25th 06 03:01 PM
CountIf formula results in the formula itself being displayed.	NewKid	Excel Worksheet Functions	9	December 21st 05 11:10 PM

All times are GMT +1. The time now is 05:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us