360days function

  • Thread starter Thread starter DanE
  • Start date Start date
D

DanE

I am having a problem with the 360days() function. I am
using Visual Basic 6.0 but using the Excel function to
calculate how many days are between two dates. The
function works fine based assuming it is based on 12 30day
months. However, when I check my data with the
spreadsheet given to me done in Excel, sometimes my
numbers match up and sometimes they are off by one or two
days. Does anyone know the reason for this?
 
Dan,

Its because the 360DAYS function assumes a set 12x30 for a year, which is
palpably not the case in normal circumstances. I understand it is used for
bond calculations or somesuch., but it makes no sense to me.

To calculate how many days, just subtract the two dates, it is all held a
decimal numbers under the covers, so you will get a true answer. If you want
just the working days, use NETWORKDAYS.
 
Days360 doesn't make sense. But before the days of computers it greatly
simplified interest computations for certain financial instruments and this
convention has remained.

PC
 
Back
Top