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
 
 
Formular

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

Name:  Formular.PNG
Views: 19
Size:  1.5 KB

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..

=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
My System SpecsSystem Spec
Reply

 Formular




Thread Tools



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 04:52 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33