Short question on Datedif

[Basta1980]

Hi,

See code below. When I run macro I get 'compile error: Sub or Function not
defined'. What am I doing wrong here?!

Regards,

Basta1980

 

[Per Jessen]

Hi

You forgot to post the code.

Regards,
Per

 

[Basta1980]

Per,

I'm sorry, still early morning here in the Netherlands;

MsgBox = datedif(a1, b1, "y")

Regards

 

[Jacob Skaria]

In VBA the function is DATEDIFF() and not DATEDIF()

MsgBox DateDiff("yyyy", Range("A1"), Range("B1"))

If this post helps click Yes

 

[OutsideObserver]

Hi

You forgot to post the code.

Regards,
Per

And here I thought I was going to read a pithy reply.