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

=IF(I3="",0,DATEDIF(I3,TODAY(),"y"))

--
HTH

Bob Phillips

"mully" wrote in message
...
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

Hi Bob

Thanks again - my old addled brain gets worse - see in the press we've got
100 million off the Glaziers - roll next season - again according to the
press Henry might be on his way to Barcelona £50 Million????
Have you seen the other query about mail merging from the user form ??? and
is it possible ?? just trying to make things so simple for the customer where
he just clicks and it does the job for him.
Just leaving to go and see him now he's back from Cardiff - back about 5pm

Thanks again -- Cheers -- Mully

"Bob Phillips" wrote:

=IF(I3="",0,DATEDIF(I3,TODAY(),"y"))

--
HTH

Bob Phillips

"mully" wrote in message
...
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