Also do you have a formula for the dues column too? That's the M column.

Thanks!

"Max" wrote:

Forgot to mention that the 2 formulas in J4 and K4 need to be array-entered,
ie press CTRL+SHIFT+ENTER to confirm the formula, instead of just pressing
ENTER. Ensure that the array-entering is done correctly; you should see Excel
insert curly braces { } around the formula in the formula bar.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---