hello everybody
this is probably really easy, but I am trying to improve an existing roster planner and need some assistance with a suitable formula .
Essentially, I'm aiming for a main page to display various KPI data, but it also needs to show who will be on which shift
I've got that bit worked out, but need to transfer the shift attendance results to the main page - see simplified example
On the annual page, each day of the year has 15 spaces for each shift, So I need to lookup today's date, and then report the shift members on that date in the appropriate place on the main page.
Grateful for any advice
regards
heffers
Bookmarks