Excel Formulas

Can anybody please help me.  I have a spreadsheet that when a document is sent out a date is entered into a column, I also have another column where I have to manually type in yes when the date is en...