thanks JE...that answered all of my questions!
"JE McGimpsey" wrote:
One way:
=((CEILING(H10/H15,1)-1)*7+H20
In article ,
"kevrgallagher" wrote:
that almost gets me where I want to go...the formula works correctly but
does not take in to account the begin date as the start date...so essentially
I'm 1 week ahead. Any suggestions on how to correct that. I must say I
would have never thought of the ceiling formula...much appreciated!
"JE McGimpsey" wrote:
One way:
=H20+7*CEILING(NPER(0,H15,H10)*-1,1)
but if your interest rate is always zero, this is more efficient:
=CEILING(H10/H15,1)*7+H20
|