Datedif not working (or user not working!)

[Oliver Dewar]

Hi All,

Trying to calculate age in years in VBA.

I'm using this:

Label10.Caption = DATEDIF(TextBox72.Value, Date, "y")

Where textbox72.value is a date that the user enters.

The problem: I get a "Sub or function not defined" error.

What am I doing wrong?

 

[Marcelo Branco]

Hi

Take a look at
http://www.techonthenet.com/excel/formulas/datediff.php

M.

 

[Oliver Dewar]

Hi,

Thanks but still don't get it.

Are you saying that I cannot get it working the way I want to?

If I can get it working, what would be the code?

Cheers,

Oliver

 

[Oliver Dewar]

Scrap that last reply of mine... I have my own answer.

I simply didn't have the extra f required in datediff!

Done,

Thanks!

 

[Marcelo Branco]

Hi,

No, i'm not saying that, but
the function name is DATEDIFF
the sintax is
DATEDIFF("y",startdate,enddate)

M.

 

[Marcelo Branco]

Scrap that last reply of mine... I have my own answer.

I simply didn't have the extra f required in datediff!

Done,

Thanks!

You are welcome and tks for the feedback

M.