Forum Discussion
Solved
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...
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)
Amazing!! the Danish works.. except for saturdays where it writes #I/T in the cells insted of the time?
Strange...
I have attached my test workbook. It won't work "as is" because I used the English names of the days of the week. What happens if you enter the Danish names of the days of the week in A9:A15 on the Norm sheet?
- I tested with your test workbook, and got som interesting results.
It was because I had left a blank space after saturday in the Norm sheet.
So I just had to delete the space and now it works 😄
Thank you so much for your help, I was not even sure it could be done.
Thank you