This formula will give a day of the week with name from a cell
=CHOOSE(WEEKDAY(C2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
Use a matching value in a cell to get another cells value
If you use match formula. It gives you the cell number of the matching value found.
=CHOOSE(WEEKDAY(C2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
Use a matching value in a cell to get another cells value
If you use match formula. It gives you the cell number of the matching value found.
No comments:
Post a Comment