Forum Discussion
Excel formula for days of the week
Hi, I am trying to get a formula that equates days to set hours ie If a cell say Monday it = 10, if it says Tuesday it = 10, If it says Wednesday it = 10, if it say Thursday it equals 8 and then ...
sandie123 There are a number of options here. I think I would recommend that somewhere on the sheet or in another sheet you create a Day-Hours table and use that table as a LOOKUP. I will also recommend you format that Table as a table and name the table something meaningful like DayHrs.
In the attached in cell B8 I used this formula:
=SUM(XLOOKUP(A1:G4,DayHrs[Day],DayHrs[Hrs],0))This assumes you have Excel 365 and if not it can get converted.