Excel date format and calculation

Copper Contributor

I Have a date in a format 21.02.2022 and another in the format of 29/07/2022

I want to calculate the difference between the 2 dates

Please help

1 Reply

@Ganesamabc Make sure that both are recognized as dates. And then, let's say the start date is in A1 and the end date in B1, you can simply enter the following, for example, in C1.

 

=B1-A1