Quote:
Originally Posted by wiganken
I think the OP has uploaded the wrong file.
|
Of course he has.
He should be trying
=A3-A2
for the number of days.
If he'd used
=TEXT(A3-A2,"
dd/mm/yyyy")
he'd have got
01/02/1900
he used
=TEXT(A3-A2,"dd")
so he only saw the red portion.