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,"="&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

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

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

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