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?

closed as unclear what you're asking by Rubén, jonsca May 20 at 1:48

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • share a copy of your sheet – user0 May 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 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

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