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

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

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

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

--
Regards,
Dave


"Barry" wrote:

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

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

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

"Barry" wrote:

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

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

Thanks very much, greatly appreciated.

"Barry" wrote:

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

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

Thanks also to you very helping me out

"Barry" wrote:

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