Subtracting Same Dates getting -1

Warpug

New Member
Joined
Apr 13, 2017
Messages
15
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?
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,955
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Can you post sample data of where this is not working as you expect and the formula you are using?
 

pedro-egoli

Well-known Member
Joined
Apr 25, 2004
Messages
1,200
Office Version
  1. 2016
Platform
  1. Windows
Excel Workbook
ABC
19/03/20199/03/20190
Sheet1


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

Watch MrExcel Video

Forum statistics

Threads
1,108,818
Messages
5,525,077
Members
409,618
Latest member
gkllc

This Week's Hot Topics

Top