Select data depening on weekday

This is a tricky one. I'm making a worktime management excel with a sheet for each month and a base data sheet. The first sheet will have the base data for a given person. Like what time they sta...

excel

Formulas and Functions

HansVogelaar
Sep 21, 2021
HenrikKruse

Let's say the first sheet is named Norm.

On the second sheet, in B11, enter the formula

=VLOOKUP(TEXT($A11,"dddd"),Norm!$A$9:$C$15,2,FALSE)

And in C11:

=VLOOKUP(TEXT($A11,"dddd"),Norm!$A$9:$C$15,3,FALSE)

Format B11 and C11 as time, then fill down.

In Danish:

=LOPSLAG(TEKST($A11;"dddd");Norm!$A$9:$C$15;2;FALSK)

=LOPSLAG(TEKST($A11;"dddd");Norm!$A$9:$C$15;3;FALSK)