Day count calculator

I know that WP 12 can readily count the number of days between two dates. 
But I would like that count for a 30/360 year for some work that I'm doing 
involving municipal bonds which use a 30 day month, and a 360 day year.

I have approached this by allowing years to be 365.25 days, and then using 
factors of 360/365 to create pretty good approximation. I then divide that 
by 180 to get the number of bond periods.

But, is there anything contained in the QP @ functions (or elsewhere) which 
will give me more precise information?

What I want to calculate is the number of 180 day (6 month) bond period 
between 2 dates.

Ron Hirsch 

Sorry for the typo - of course I meant "QP 12" in my first sentence.

Ron Hirsch

+++++++++++
"Ron Hirsch" <rbhirsch1h4i3r9s@NOSPAMcomcast.net> wrote in
message 
news:47b17e27$1_1@cnews...

I know that WP 12 can readily count the number of days between two dates.
But I would like that count for a 30/360 year for some work that I'm doing
involving municipal bonds which use a 30 day month, and a 360 day year.

I have approached this by allowing years to be 365.25 days, and then using
factors of 360/365 to create pretty good approximation. I then divide that
by 180 to get the number of bond periods.

But, is there anything contained in the QP @ functions (or elsewhere) which
will give me more precise information?

What I want to calculate is the number of 180 day (6 month) bond period
between 2 dates.

Ron Hirsch

Sorry for the typo - of course I meant QP12 in the opening sentence.

Ron Hirsch

+++++++++++++++++
"Ron Hirsch" <rbhirsch1h4i3r9s@NOSPAMcomcast.net> wrote in
message 
news:47b17e27$1_1@cnews...

I know that WP 12 can readily count the number of days between two dates.
But I would like that count for a 30/360 year for some work that I'm doing
involving municipal bonds which use a 30 day month, and a 360 day year.

I have approached this by allowing years to be 365.25 days, and then using
factors of 360/365 to create pretty good approximation. I then divide that
by 180 to get the number of bond periods.

But, is there anything contained in the QP @ functions (or elsewhere) which
will give me more precise information?

What I want to calculate is the number of 180 day (6 month) bond period
between 2 dates.

Ron Hirsch

Hi Roy,

Thanks -

I had hoped there was something in there for this. But I didn't know what to 
search for.

I'll check out @D(360)

I knew I could count on you. :-)

Ron

Ron Hirsch wrote:
> What I want to calculate is the number of 180 day (6 month) bond period 
> between 2 dates.

@COUPNUM

Cheers,
Uli