Hi Ibvalentine
I notice that you changed your sample file.
You're not calculating the same way, but still not working every time.
I took your old form and simplified the formulas, kept your format, are you
still interested.

Regards
John
"John" wrote in message
...
Hi ibvalentine
You're welcome but still not right,changing D760 to D730 will change tthe
number to 1 but it is moving to the $1.56 section. the total number of days is
41, it should stay in the 1.25$ section.I think I would use a different
approach but sorry I don't have the time at this moment.
HTH
John
"ibvalentine" wrote in message
...


"John" wrote:
John,

Thanks for finding that error. the first nested if statement had D760
instead of D730 for the logical test.

Hi
I believe there is a mistake in your formula.
Change the starting date on the first line to feb.20
Sample from your file :2/20/2009 4/1/2009 40 1 0 0 11 0
$13.75
It's giving 11 days in April but if you change it to March, its giving 1
which I
think it should be right. I'm not sure why it's not working in February but
working in January & March.
Regards
John