Now your field values are duals, still showing the formatted date as text representation, but holding also a number you can use in dat calculations, e.g. for calculating the date difference, just subtract two date values.
Set DateFormat = 'DD-MMM-YY';
[Close Date]-[Open Date] as Duration
INLINE [ // INLINE table only used for demonstration