This is the second of my series in creating a KPI dashboard. You can check out the first blog post here. You can download the completed file for this session here in which I show you how to calculate calendar days, working days and use the IF function to identify entries that are inside and outside the KPI.
Note that the file in the video is a little bit different from the file you will download here but you have all the essentials in it – certainly enough to see how it is done.
Here’s the video.