over my head- need function help
 

Hello,

In plain english (and some excel terminology), I need to create a function
to do this:

I have a maturity date, frequency (annual, monthly, semi annual) and
settlement date (which comes before the maturity date).

- count the number of occurences of:

edate(maturity,-(frequency * 100) )

that is less than or equal to the maturity date and greater than settlement
date.

The 100 in the formula is arbitrary, just put it there to have enough period
to go beyond(i.e. before) the settlement date.

thanks. I need to figure this out, but am very much a VBA beginner.

over my head- need function help
 

correction:

I have a maturity date, frequency (annual, monthly, semi annual) and
settlement date (which comes before the maturity date) and specified date.

- count the number of occurences of:

edate(maturity,-(frequency * 100) )

that is less than or equal to the specified date and greater than settlement
date.

The 100 in the formula is arbitrary, just put it there to have enough period
to go beyond(i.e. before) the settlement date.

thanks. I need to figure this out, but am very much a VBA beginner.



"Ivanl" wrote:

Hello,

In plain english (and some excel terminology), I need to create a function
to do this:

I have a maturity date, frequency (annual, monthly, semi annual) and
settlement date (which comes before the maturity date).

- count the number of occurences of:

edate(maturity,-(frequency * 100) )

that is less than or equal to the maturity date and greater than settlement
date.

The 100 in the formula is arbitrary, just put it there to have enough period
to go beyond(i.e. before) the settlement date.

thanks. I need to figure this out, but am very much a VBA beginner.