Calculate current day and time, insert data according to a variable

[mvrht]

I have a surgery opening times spreadsheet that currently displays waiting times in the "LIVE" worksheet based on the current time, pulling details from the DEFAULT worksheet. I have two additions I would like to make but am struggling with:

1) I want to add in weekends and have the LIVE tab not just get the current time with now() but also the day so it can pull in the relevant results. I have put a beta example in FULLWEEK

=ArrayFormula(vlookup(timevalue(A2),{iferror(value(regexextract(Default!A2:A,"(.+)\s-"))),Default!B2:E},{2,3,4,5},1))

2) Have a variable set in STATUS that changes the LIVE worksheet to pull in data from whatever worksheet name is entered in =STATUS!A1

ATTEMPT =ArrayFormula(vlookup(timevalue(A19),{iferror(value(regexextract(STATUS!A20:A,"(.+)\s-"))),STATUS!B20:E},{2,3,4,5},1))





I have put an example in a couple of online spreadsheets:

https://docs.google.com/spreadsheets/d/1YRQ9uduGhliY9FJ96ANCN1cf3D5rKTR08426S6EUyVs/edit?usp=sharing

If you want to have a play, you can even make a copy with this link

https://docs.google.com/spreadsheets/d/1YRQ9uduGhliY9FJ96ANCN1cf3D5rKTR08426S6EUyVs/copy

 

[Fluff]

Is this a googleSheets question or an Excel question?

 

[mvrht]

Is this a googleSheets question or an Excel question?

Excel, but I have imported the .xlsx into Google Sheets so it can be demonstrated/copied online

 

[Fluff]

Those formulae you showed are GoggleSheets formulae & not Xl formulae.
You might do better by showing your Xl formulae