Hi all,
I have a formula which returns a specific shift target based on the criteria from another cell. The problem I am having is that the particular shift target changes on a Friday due to shorter shift times. I know I need to reference the date on the taskbar but not sure how to do this.
Any help would be very much appreciated.
Thanks
I have a formula which returns a specific shift target based on the criteria from another cell. The problem I am having is that the particular shift target changes on a Friday due to shorter shift times. I know I need to reference the date on the taskbar but not sure how to do this.
Any help would be very much appreciated.
Thanks