Get Day of week based on other cells partial date

[jimjones1958]

Hello,

I would like to know how to get the day of week based on inputs from the day number, Month (in cell L3) and Year (in cell L2)?

2021-05-10_11-19-57.png

[JohnTopley]

Try

=WEEKDAY(DATE($L$2,MONTH($L$3 & 0),B3),2)

2 gives Monday to Sunday
1 gives Sunday to Monday

Actual days ...


=LOOKUP(WEEKDAY(DATE($L$2,MONTH($L$3 & 0),B3),2),{1,2,3,4,5,6,7},{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"})