Your formula 19/11/2021 - 18/10/2021 =TEXT(A3-A2,"dd") is correct but it returns the day on which day 32 starting 01/01/1900.
Using a text function to return dates might get you in trouble for later analysis. much easier to use A3-A2 and format as suggested. The underlying value will not change and stay a number
|