Wildcard in IF() function

[Ezra]

I am attempting to us the following formula "=IF
(C16="Date*",C16,B15)The B16 field contains dates that are
labeled like this: Date: 07/28/2003. I am trying to have
the cell look for the dates in the C column and fill in
the B column with either the new date or the date from the
cell above. I have tried multiple things to get it to
take the wildcard with no luck.

Thank you in advance,

Ezra

 

[DD]

If just looking for word Date this will help

=IF(FIND("Date",C4,1)=1, "Found it", "Not here")

Dave