Another User Form Query

[mully]

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

[Bob Phillips]

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

--
HTH

Bob Phillips

"mully" <[email protected]> wrote in message
news:[email protected]...
> 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

[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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>