Formula to Track Where Up to Against a Target

Hi all,

I run a business where we set monthly targets for our staff. I have a very simple formula at present which is basically tracked like the following example:

Target for month: 40
As of Today: 10
Difference: -30

We have targets for different key areas of the business, so it would be massively helpful if I could identify if the staff were on target to hit target for the month, day by day, if that makes sense?!

So, for example, although the target is 40, it is for the entire month so I wouldn't expect them to have reached it very early on, so if there are 23 working days in January, they should be booking 1.74 appointments per day. If it were the 10th working day of the month, they should technically be on 17 appointments so are 7 behind where they should be at this point in the month.

If I can master this formula, it would help apply focus on where they need to catch up! If I can do it against real time IE the date then that would be outrageously good!!

Hope this makes sense and thanks in advance to whoever may be able to help me!

Thank you!!

Do you have an example workbook for us to look at?

Without knowing how the data is entered or how its being tracked its tough to figure out what would be best.

Thank you for this! I'm not the best with excel formulas but I'll give this a go!

TEST.xlsx

This is an example of the sheet I am using. So the bottom row needs to be the number of where they should be at for that day in relation to the target set and the number of days gone in the month so far.