[Anonymous]

Should i be able to copy and paste what you have there(minus the sub name)? I'm still getting;
"Compile error:  Wrong number of arguments or invalid property assignment"

It highlights datediff when it throws the error.

Sub datediff()
Dim d1 As Date
Dim d2 As Date
Dim ds As String
    ds = "12/1/2017"
    d1 = Format(Now, "MM/DD/YYYY")
    d2 = CDate(ds)
    Debug.Print datediff("d", d2, d1)
End Sub