Excel calander function error??

[scheinz]

I am calculating the number of days of interest owed
between two dates. I am using the formula "days360" I
did this for a few dates:
2/28/2004 to 3/5/2004 and get 7 days
3/1/2004 to 3/31/2004 and get 30 days

Since there is 29 days in february I should get 6 days in
february compared to the 30 days in March. This makes my
spread sheet inaccurate and one day off in february. How
is this discrpency corrected? or is there a better
formula?
Kenn

 

[Andy B]

Hi

The DAYS360 formula assumes 30 days for each month. That is why you get
discrepancies. You could just take the earlier date away from the later
date:
=A2-A1
to get the difference between them in days. Format the result as General.

 

[scheinz]

How do you format the results as General?

-----Original Message-----
Hi

The DAYS360 formula assumes 30 days for each month. That is why you get
discrepancies. You could just take the earlier date away from the later
date:
=A2-A1
to get the difference between them in days. Format the result as General.

--
Andy.





.

 

[Andy B]

Hi

Right-click on the cell with the result in. Select Format Cells . . and on
the Number tab select General from the list on the left.