Difference of date

hi I have excel sheet in which one column has date time. I need the date difference in days of that

so please help me for that.

that column are in datetime format.

New Microsoft Excel Worksheet.xlsx (8.4 KB)

Syntax: DateDiff(DateInterval, Date1,Date2)
Code: DateDiff(DateInterval.Day,“2021-01-30”,“2022-01-30”)

Hope It helps

i already tried but not work

Which will be the second date, used for the compare?

In general we can do (used todays date as second date)