Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have start date march 26, 2006 in cell k3 and D8:o8 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 -- KK |