=countif (h3:h16">=01 01 2006") how to substitute cell for date

[Barry]

this formulas works fine, however how do is substitute a a cell for the
actual date, i.e. the date I want to refer to is b1. I have tried using the
cell reference but it does not work

 

[David Billigmeier]

=COUNTIF(H3:H16,">="&B1)

 

[Kleev]

Use the concatenation operator:
=countif(h3:h16 ">=" & b1)

 

[Barry]

Thanks very much, greatly appreciated.

 

[Barry]

Thanks also to you very helping me out