wrong date calculate

New Contributor
I am using Excel to create a database and I got an error in the Excel calculation.
I am attaching a file, why in E117 the value is too strange?..
3 Replies
best response confirmed by allyreckerman (Microsoft)


It is a rounding error caused by the way dates and times are represented in binary notation. To get rid of the discrepancy, use the ROUND function. In E3:


Fill down.

@Hans Vogelaar 
Thank you, now it look ok