mully

Posts: n/a

Another User Form Query

Hi

Using Excel and the following formula =DATEDIF(I3,TODAY(),"y") in the User
Form Text Box it shows 105 if I haven't entered a date in cell I3 is there
anything I can add to the above formula that will show a zero or just leave
the Text Box blank until a date is entered in cell I3.

Any help much appreciated

Cheers ---- Mully

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
User Form to Mail Merge	mully	New Users to Excel	0	May 24th 05 11:45 AM
opening a user form	maxzsim	Excel Worksheet Functions	2	May 4th 05 10:03 AM
user form	static69	Excel Discussion (Misc queries)	1	February 6th 05 08:43 PM
Data Entry Alert in User Form	Kev	Excel Discussion (Misc queries)	6	January 8th 05 03:01 PM
A "previous" button on a user form	Anthony Slater	Excel Discussion (Misc queries)	3	November 29th 04 05:57 PM

All times are GMT +1. The time now is 06:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us