Fish0926
New Member
- Joined
- Sep 25, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
- Web
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
What should I enter? Thanks!
Sub Date()
Range("CH2").Formula = "=DATEDIF(BQ2, TODAY(), "D")"
End Sub