I've tested the lookup formula within the same sheet to enter a date and it returns a period date (For Work), but when i want to search from another sheet it doesn't work
Below is on the same sheet
Below is from another sheet that doesnt...
I would like to create a Service Turnaround Time measure that shows the MTD, QTD, and YTD % change that can be calculated on a custom calender.
Making the calculations work according to the custom calender are the challenge since to my understanding time intelligence functions to not work with...