Date diffrence in days, weeks and months.

[Pablo56]

Hi. I have a columb A21 with a custom date of Wed 07 Desc-2022. Columb B has =NOW()-A21
I would like columb C=weeks and possibly D=months.

Is this possible?

I added a cell A22 the current date NOW() and made the formula read DATEDIF(A21, A22,"d").

 

[arnelgp]

create a Public function in a Module:

Public Function fnDateDiff(ByVal interval As String, ByVal Date1 As Date, Date2 As Date) As Variant
' for now interval can be "w" (week) or "m" (month)
If interval <> "w" And interval <> "m" Then
fnDateDiff = Null
Exit Function
End If
fnDateDiff = VBA.dateDiff(interval, Date1, Date2)
End Function


to get the Weeks:
=fnDateDiff("w", A21, A22)

to get the Months:
=fnDateDiff("m", A21, A22)