Find Date difference in excel

Hi,

i want to find the day difference for “From date and To Date”. Anyone please help…

DateDifference.xlsx (8.2 KB)

Hi @Muthulakshmi_Thangamuthu

Use ForEach Row and store the value into variables as below

You can use DateDiff function to calculate the difference

Syntax : DateDiff(DateInterval, Date1, Date2)
Code: DateDiff(DateInterval.Day, YourvariableofFromDate, Yourvariable of ToDate)

It will return the number of days between two dates

Hope this helps you

Thanks