Hello All,

I have a table like attached.

Put in the if loop to get the week offs, wanted to know if there is any other formula that would cut down the length of the already written formula.

=IF(AND(A2="",B2=""),$A$1&","&$B$1,IF(AND(B2="",C2=""),$B$1&","&$C$1,IF(AND(A2="",G2=""),$A$1&","&$G$1,IF(AND(C2="",D2=""),$C$1&","&$D$1,IF(AND(D2="",E2=""),$D$1&","&$E$1,IF(AND(E2="",F2=""),$E$1&","&$F$1,IF(AND(F2="",G2=""),$F$1&","&$G$1)))))))

Thanks!Weekoffs.xlsx