Difference of date

[Lakshya_Garg2 (Lakshya Garg)]

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)

[NervousTuber (vinit mhatre)]

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

Hope It helps

[Lakshya_Garg2 (Lakshya Garg)]

i already tried but not work

[ppr (Peter)]

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…

@Lakshya_Garg2

I need the date difference in days of that

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

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