1

I'm making an attendance sheet for my team, how do I make only certain days like Mon Tue Wed appear in the top column?

  • share a copy of your sheet – user0 May 19 '19 at 9:57
  • Welcome. Please add a brief description of your search/research efforts as is suggested on How to Ask. – Rubén May 19 '19 at 18:15
0

=ARRAYFORMULA(TRANSPOSE(QUERY(TEXT(TO_DATE(ROW(
 INDIRECT("A"&DATE(YEAR(A1), MONTH(A1), DAY(A1))):
 INDIRECT("B"&EOMONTH(A1, 0)))), "ddd"), 
 "where Col1 = 'Mon' or Col1 = 'Tue' or Col1 = 'Wed'")))

0

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.