K
Kay
I have start date march 26, 2006 in cell k3 and D88 the month from july to
june below I have a formula to issue 1 every four months (that is row 9)
march, july, nov ( as below) The total now by the times it get to june is 3.
I need a formula to calculate in row 10 to make the month after the start
date (in this case april only to equal to 1 it could also be less than 1.
That Month alone cant be more than 1. Any suggestion?
july aug sept oct nov dec jan feb mar apr may june
1 1 1
june below I have a formula to issue 1 every four months (that is row 9)
march, july, nov ( as below) The total now by the times it get to june is 3.
I need a formula to calculate in row 10 to make the month after the start
date (in this case april only to equal to 1 it could also be less than 1.
That Month alone cant be more than 1. Any suggestion?
july aug sept oct nov dec jan feb mar apr may june
1 1 1