Countif Formula

[Quinton]

Hello, sorry this is a simple one but I cant get it to work.

I have a date of 14/03/2011 in cell A1. I have another date of 14/05/2011 in Cell B1. Because the date in cell A1 is earlier that Cell B1 I want it to count 1.

Itried the following formula =COUNTIF(A1,"<B1"). Thisshows a result of 0 (once I have formatted the cell to a number and not adate). Any ideas would be really appreciated & many thanks inadvance.

<b1") appreciated.=""></b1")><b1"). be="" would="" ideas="" Any="" a="" not="" and="" number="" to="" cell="" the="" 0="" of="" result="" thanks="" many="" &="" appreciated="" really="" formatted="" have="" I="" (once="" inadvance.

</b1").><b1") appreciated.=""></b1")><b1"). be="" would="" ideas="" Any="" a="" not="" and="" number="" to="" cell="" the="" 0="" of="" result="" thanks="" many="" &="" appreciated="" really="" formatted="" have="" I="" (once="" inadvance.

</b1").><b1") appreciated.=""></b1")>

 

[TonyUK72]

I think you can simplify more.

*for some reason my formula wont post

Pseudo

IF A1 is less than B1 = 1 else BLANK

<b1,1,"")[ code]<b1,1,"")<b1,1,"")<="" html=""></b1,1,"")[>

 

[Quinton]

I think you can simplify more.

*for some reason my formula wont post

Pseudo

IF A1 is less than B1 = 1 else BLANK

<b1,1,"")[ html="" code]<b1,1,"")<b1,1,"")<=""></b1,1,"")[>

Thanks yes I cant post my formula as well (Strange). Ill try again just in case =COUNTIF(A1,"<b1").

If not can you email it to me quintonhurdidge@pennyfarthinghomes.co.uk (many thanks in advance)</b1").

 

[TonyUK72]

Another try, just remove the surrounding speech marks

"=if(a1>b1,1,"")"