Thread: Formatting?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Saucychic68
 
Posts: n/a
Default 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