Formular

yimveasna · 28 Feb 2014

Hello Sir,
I have a question that,
i have one Excel spreed sheet
and at

Here is the formula :
1-At column A , the date put by manually
2-At Column B , The date put by formula = today()
3-At the column C, It's the result between column A and B,
The Formula at Column C IF(A1>0,DAYS360(A1,B1),)

I wonder why Column A and B are equal date, why the result at Column C is -2?
It's should be 0 at Column C

TanyaC · 02 Mar 2014

If you are simply trying to calculate the difference in the two dates...

In your example in C1..

=IF(A1>B1,A1-B1,B1-A1)

The result for your example should be 0.

How the date looks is largely irrelevant, as that is accomplished by cell formatting. The actual content for dates is a serial number.

hth
Tanya