Posted to microsoft.public.excel.misc

simoncottle

Posts: n/a

Countif - recognition problems with dates

=COUNTIF(Pitches!$C$15:$C$67,"<=Pitches!B5+3")

Im trying to get countif to recognise dates that are less than three
days away. B5 is todays date..

Any suggestions on where I am going wrong?

--
simoncottle
------------------------------------------------------------------------
simoncottle's Profile: http://www.excelforum.com/member.php...o&userid=33122
View this thread: http://www.excelforum.com/showthread...hreadid=529744

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
Having problems calculating dates in Excel.	Russell Bachmann	Excel Worksheet Functions	1	March 9th 06 05:55 PM
Countif on multiple dates	Jim	Excel Worksheet Functions	6	December 13th 05 05:56 PM
COUNTIF using Dates	WLMPilot	Excel Worksheet Functions	1	October 7th 05 12:51 AM
Countif using dates	Bugaglugs	Excel Worksheet Functions	11	August 23rd 05 05:16 PM
COUNTIF With Multiple Dates, Columns and Text	Shannon	Excel Worksheet Functions	4	November 26th 04 11:12 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us