Formatting?
I use an excel data sheet for a mail merge of letters. The data I am having
trouble with is dates. Here is the formula I use:
=IF(Data!F31<TODAY(),"",IF(Data!F31(TODAY()+63)," ",Data!F31))
The dates that I need show up and the dates I dont need seem to be blank,
however, those blank cells are generating "12:00:00" into my mail merge
document when I need those cells to read blank. Any ideas?
Michelle
|