Posted to microsoft.public.excel.misc

Saucychic68

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting Error	ddate	Excel Worksheet Functions	0	May 5th 05 09:00 PM
difficulty with conditional formatting	Deb	Excel Discussion (Misc queries)	0	March 23rd 05 06:13 PM
conditional formatting question	Deb	Excel Discussion (Misc queries)	0	March 23rd 05 02:07 AM
Formatting dates in the future	Compass Rose	Excel Worksheet Functions	3	January 17th 05 10:39 PM
Copy conditional formatting across multiple rows?	Gil	Excel Discussion (Misc queries)	1	January 11th 05 11:27 AM

All times are GMT +1. The time now is 12:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us