Forum Discussion
Solved
Formula to match Day of Week Name
I want to get the day of the week from a date and then evaluate if that matches a cell with different days of the week. 8/28/2023 is a Monday (text(cell,"dddd") I want the formula to indicat there ...
For older versions of Excel, you may try the following formula...
=(LEN(A2)-LEN(SUBSTITUTE(A2,TEXT($B$1,"dddd"),"")))/LEN(TEXT($B$1,"dddd"))For Excel 365, you may also try the following formula...
=SUM((TEXTSPLIT(A2,"; ")=TEXT($B$1,"dddd"))*1)
For older versions of Excel, you may try the following formula...
=(LEN(A2)-LEN(SUBSTITUTE(A2,TEXT($B$1,"dddd"),"")))/LEN(TEXT($B$1,"dddd"))
For Excel 365, you may also try the following formula...
=SUM((TEXTSPLIT(A2,"; ")=TEXT($B$1,"dddd"))*1)
- Thank you!
