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

Formatting?
 

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

Formatting?
 

Now I get the message "you have entered too many arguements for this function"

"bpeltzer" wrote:

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

Formatting?
 

Ok, I am not sure if there is an easier way but I have found an answer that
works. I copied the entire data sheet and "paste special" (checking format)
onto a new sheet. I then linked that sheet to my mail merge. This works just
like I need it but I wonder if there wasn't an easier way to get my data to
do what I want without using 2 seperate worksheets?

"Saucychic68" wrote:

Now I get the message "you have entered too many arguements for this function"

"bpeltzer" wrote:

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