Another User Form Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mully - 24 May 2005 12:52 GMT

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 to this Message

Bob Phillips - 24 May 2005 14:20 GMT

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

Signature

HTH

Bob Phillips

> Hi
>
[quoted text clipped - 6 lines]
>
> Cheers ---- Mully

Reply to this Message

mully - 24 May 2005 14:38 GMT

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

> =IF(I3="",0,DATEDIF(I3,TODAY(),"y"))
>
[quoted text clipped - 9 lines]
> >
> > Cheers ---- Mully

Reply to this Message