If the specific date is in cell A1, reference using absolute referencing:

=IF(B1$A$1,B1,"")

If the date is not in a cell, you could use

=IF(B1DATEVALUE("July 10, 2009"),B1,"")

Other than that, your question is a bit fuzzy around the edges...

HTH,
Bernie
MS Excel MVP






"brivera" wrote in message
...
what would a formula look like that compares differnt dates (different
cells)
to one specific date, please?