When Subtracting Dates to get number of days it comes out as "4382"

Ruth2002

New member
Joined
Aug 29, 2019
Messages
9
Reaction score
0
Points
0
Excel Version(s)
Excel 365
I'm subtracting two dates in my document. But instead of the difference in days it comes out with a 43832 or really a date.

date error.JPG

At one point it was working.
 
Check the format for Col R
 
The first argument of MATCH is usually a single value/cell, not an entire column?

Perhaps attach a file, trimmed down to a few rows in each table (which will still produce a value) to show the error and state the expected result(s)
 
Back
Top