Subtracting Same Dates getting -1

[Warpug]

I have dates in two columns on the same spreadsheet, there are a series of records where these two date columns are identical dates so I would expect my result to be 0, but I’m getting -1. What could be causing this?

 

[Scott Huish]

Can you post sample data of where this is not working as you expect and the formula you are using?

 

[pedro-egoli]

Excel Workbook
	A	B	C
1	9/03/2019	9/03/2019	0
Sheet1

Format for C1 is General, if formatted as number it shows 0.00