Table about commission (daily, monthly, weekly"

Hi All,

First of all, I wish you all a Happy New Year!

I would like to make design a table that includes the following:

1- The number of outbounds call that every agent made, If the agent achieves his sales target of these call he can get a bonus or a commision.

2- The agent can get a bonus only if he achieve 4 successful activation daily, if he exceeded this target for example makes 7 successful activation daily the extra successful activation will be carried over to the next day's target.

3- The minumum amount of successful daily activation should be not less than 4, the minumum amount of successful weekly activation should be not less than 10, and the minumum amount of successful monthly activation should be not less than 25

I need your support in desging such a table. I wonder if If condition can be used in this case

The attached fiel is a copy of what I came up with .

Thank you Etaf for your reply.

I have some question on which I need your support:
What do you mean by the following:

you could use Weeknum() to get the weeks - may have an issue at the start or end of the year as the weeknum can have just a couple of days in

Appreciate it if you let me know how can I do it.

The commisssion should be paid monthly.

if the sales agent achieved 0 1st week 0 2nd week and then on the last 2 weeks of a month , had 25 - how would that be counted ?

The commission is 4% whether it if daily, weekly, or monthly. He should get the commission by the end of the month.

Thank you for your reply. I would be more than thankful if you can give me an example in a simple design.

I just wanted to attract yoru attention to the following:

The agent can get a bonus only if he achieve 4 successful activation daily, if he exceeded this target for example makes 7 successful activation daily the extra successful activation will be carried over to the next day's target.

I think that I should add another column for the above point.

Thank you Etaf. I wonder if there is any way to use If condition in my case. If yes, please let me know and give me an example if you don't mind.

I would really much appreciate it if you can let me know how "if function" can be used in my case.

How about this
=IF(D2>=4,10,0) in column E
=IF(D2>4,D2-4,0) in column F