How to calculate the date different in excel with current date

[jais1609 (Jeyasankar S)]

Hello,

How to calculate the date different in excel with current date.

Excel file was download from the browser and need to calculate the date different with current date.

[Manish540 (Manish Shettigar)]

This link may help you, @jais1609

Difference between two dates

Hello! You can use the DateDiff function. Example: Syntax: DateDiff(DateInterval, Date1,Date2) Code: DateDiff(DateInterval.Day, “2016-01-30”,“2016-01-30”) It will return the number of the days between the two dates as Integer Type. Hope It helps! Regards,

[jais1609 (Jeyasankar S)]

Thank you so much Manish. I will try and reach out if any questions.

[jais1609 (Jeyasankar S)]

I have tried but the current date was charged diff was mismatch