2 dates difference > want in Days using VBA code

Help Studio
1

column Sent date has > 2020-11-03
based on this i have to compare sentdate with todays date = result i need in days after filter only 2 days old
using vba code i need this

2

@Deepthi_Borra,

Check like this,

DateDiff("d", sentDate, TodaysDate)
3

okay.
day=2
But i want to check this for all rows inside excel .Can you please form a code and reply.

i have tried this > it is correct ???

for row To tempSheet3.Range(“A2:AD” & tempSheet3.Cells(Rows.Count, “A”).End(xlUp).Row)

If tempSheet2.Range(“W” & tempSheet2.Cells(Rows.Count, “W”).End(xlUp).Row) = Date - 2 Then

sheet totals A to AD
date column is in W