VBA Code to enter formula - Error

[Fish0926]

I want to calculate the day different between today and the date in cells. I try to use VBA to enter, but it has an error.
What should I enter? Thanks!

Sub Date()
Range("CH2").Formula = "=DATEDIF(BQ2, TODAY(), "D")"
End Sub

 

[Anthony47]

Try

Range("CH2").Formula = "=DATEDIF(BQ2, TODAY(), ""D"")"

Bye

 

[Peter_SSs]

Welcome to the MrExcel board!

There is not much point using DATEDIF to calculate the difference in days. It is simpler to just subtract the dates.

Range("CH2").Formula = "=TODAY()-BQ2"

 

[Fish0926]

Solved

Thanks for the responses

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.