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 :
But it does not work. Maye it is that dateDif Excel function cannot be converted in VBA function?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
Thx!
Werner
Bookmarks