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
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
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"})
Last edited by JohnTopley; 05-10-2021 at 12:09 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks