Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Date2 - Date1
But Date2 should to have the same format as Date1
So Date#(Date2,'DD/MM/YYYY') as Date2
Check this:
Use interval() function
Interval(date1-date2,'DD')