Excel calander function error??

  • Thread starter Thread starter scheinz
  • Start date Start date
S

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





.
Click to expand...
 
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.
 
Back
Top