Subtracting Dates VBA

  • Thread starter Thread starter Werner
  • Start date Start date
W

Werner

Hi,

I want to subtract two dates 'YYYYY-MM-DD' but by doing in VBA and
pointing to their respective cells and dump the result in another
cell.

For example, I am working on this experiment :
Sub datescalcul()
Dim Baux As Double
Baux = Application.DATEDIF(Worksheets("Formulaire").Range("I16").Value,
Worksheets("Formulaire").Range("J16").Value, "m") / 12
sheets("Formulaire").Range("K16").Value = Baux
End Sub
Click to expand...

But it does not work. Maye it is that dateDif Excel function cannot be
converted in VBA function?
Thx!

Werner
 
I forgot to mention that the error is on my subtraction. It says
property or method not managed by this object. And I want to return a
numer of years and have decimal or where we are in the last years (e.g.
3 and a half year 3,50).

Werner
 
Back
Top