One way:

A1: <date1
A2: <date2
A3: =A2-A1

Format A3 as General or another Number format.

this works since XL stores dates as integer offsets from a base date.

In article ,
sdmccabe wrote:

Could you please suggest a formula to compare the contents of two cells
containing date values and display the difference in days?