Hello,
I am in the process of creating a maintenance schedule for some equipment (Weekly, Monthly, 6 Months and Annual).
I have a list of equipment in a column and a planner in other columns, i want to repeat the letter "W" when the corresponding cell date is > the previous weekly maintenance +7 days, letter M should appear when the last three columns had "W" , S should appear when the letter M was repeated 5 times, etc. is there a vba code or formula to automate that? i tried using the following formula, which worked fine for the first couple entries but then the letter M keeps repeating across the row: =IF(AND($H$18="W",O15=$H$15+(7*(COUNTIF($H$18:N$18,"W")))),"W",IF(COUNTIF($H$18:N$18,"W")=3,"M",""))
I am in the process of creating a maintenance schedule for some equipment (Weekly, Monthly, 6 Months and Annual).
I have a list of equipment in a column and a planner in other columns, i want to repeat the letter "W" when the corresponding cell date is > the previous weekly maintenance +7 days, letter M should appear when the last three columns had "W" , S should appear when the letter M was repeated 5 times, etc. is there a vba code or formula to automate that? i tried using the following formula, which worked fine for the first couple entries but then the letter M keeps repeating across the row: =IF(AND($H$18="W",O15=$H$15+(7*(COUNTIF($H$18:N$18,"W")))),"W",IF(COUNTIF($H$18:N$18,"W")=3,"M",""))