I am working in LibreOffice Calc v126.96.36.199 and I am looking for some assistance on being able to Reference/Return Cell Data on one Sheet based upon the Day of the Week (Sun, Mon, etc).
I have multiple Sheets that range: WEEK 1, WEEK2, … WEEK 12, WEEK 13 that contains sales data for that specific Week. Contained within each week’s sheet are the following Columns: Day of the Week (A7:A14), Daily Sales (N7:N14) and Number of Customers (BH7:BH14).
On a separate Sheet called WTD, I would like to Reference, based on the current Day of the Week, the Sales and Number of Customers for that specific day of that week.
I am using a Cell on the WTD Sheet called Current Week (WTD.I8) that contains an Integer representing the week number.
Entering an Integer between 1 and 13 allows me to Reference Specific Sheets based upon this number.
I utilize this integer along with functions such as INDIRECT.
Example: =INDIRECT(“Week “&WTD.$I8-1&”.N14”)
In the above example it will return the Previous Weeks (Week 2) Total Sales (N14) since I8 = 3
I am stumped on finding a way to Return a Cell value based upon the Current Weeks number and Day of the Week.
Current Week: 3
Today’s Sales - Last Week: $XXXX (Returns the Value on Sheet: Week 2 for today (Wed).
I hope that I have not made this too confusing to understand.
Thanks for reading…