I am using the following code to return an integer value representing the number of days between two dates.
I would like to return the absolute value of the number of days between the two date values. Why is my abs function failing here? Receiving the Object doesn't support this property or method error.
Code:
With Application
Z = .Abs(TS.Cells(Q, 2).value - TS.Cells(B, 2).value)
End With
I would like to return the absolute value of the number of days between the two date values. Why is my abs function failing here? Receiving the Object doesn't support this property or method error.