Forum Discussion

sandie123's avatar
sandie123
Copper Contributor
Feb 18, 2022

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

excel

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Feb 18, 2022

    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. 

Resources