I have one column, with dates in *50,000 over a month.

I want to create another column in column D which enters a value Yes or
No depending on what date corresponds in Column A

I would usually use
=IF(A9="01/05/2006","Yes","No") to get a Yes in Column D

However; I want to have multiple dates in this Formula,

and I can't get dates to work with 'IF' Formulas.

So If for instance I wanted a yes in Column D for all dates 01/05/06,
03/05/06 & 16/05/06 what would the formula. A 'No' would be the value
inserted for any other date.

Thanks.


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=551935