Forum Discussion
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...
First, your 'Yes' column sounds a bit redundant? Filter the date column for blanks or not blanks and you have the same information?
But to answer your question, this will do it. (assume your date is in A1, you will need to change that to match your table). =if(A1="","","Yes")
Copy that down your yes column.