Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Use the CHOOSE function

=CHOOSE(WEEKDAY(J19,2),"Monday", "Tuesday", "Wednesday","Thursday","Friday","Saturday","Sunday")