How to calculate the date different in excel 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,