Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) |