Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Formular

28 Feb 2014   #1

Windows 7 64 bit

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

My System SpecsSystem Spec
02 Mar 2014   #2

Linux Mint 17 Cinnamon | Win 7 Ult x64

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

In your example in C1..


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.

My System SpecsSystem Spec


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 16:07.

Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App