Ouf !
Now Mr X is going to have to sit up and take notice !
Bye and thanks.
Nth



"Fred Smith" a écrit dans le message de news:
...
You're right. ACCRINTM should give the same results as my formula. I, of
course, was thinking of ACCRINT, which is substantially different.

Sorry for leading you astray.

Fred.


"Nth" wrote in message
...

Try them with any other period, like 15 days which you used in your
initial
example.

Hi Fred,
Nice to see you back,
There you go .... a new pic with irregular dates,
http://www.fransysco.net/interest/in...ular_dates.gif

Theres a difference between the
ACCRINT function - and the -
ACCRINTM function.

ACCRINT requires intervals.
But I'm using ACCRINTM which has a maturity ( = settlement ?) date.
So there's an issue date and a settlement date, but no (other) periods.

Nth