Seems like the mail merge is recognizing a numeric field and attempting to
treat "" as 0. I'd try creating a text field instead by changing the last
part of your formula, Data!F31, to text(Data!F31,"m/d/yy"). Since your cell
will consistently contain text, the mail merge may stop trying to help.

"Saucychic68" wrote:

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