Hi, I am trying to use an IF statement looking at a cell the is a date but am having trouble. Say cell C9 is formatted as a date and i want cell C11 to look at C9 and if it has a specific date then i want cell C11 to equal the contents of cell C10 otherwise keep cell C11 blank. Here is what i tried without success:
=IF(C9=(9/1/09),C10,"")
the date in cell C9 was 9/1/09 but the results are always a blank cell for C11.
Any thoughts?
Bookmarks