maybe...
=COUNTIF(Pitches!$C$15:$C$67,"<="&Pitches!B5+3)
simoncottle wrote:
=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
--
Dave Peterson