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