Excel formula for days of the week

[sandie123]

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 to add the whole month together. 

[#2]

@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.