Hi, I am trying to calculate commissions for certain people. Commissions are calculate based on how the company performs as a whole "Bookings". When that person leaves "End Date",
I want the calculation to happen as a proportion of that month. In the example I have, I would like the calculation to happen for May for only the days May 1-15 for example. Is there a universal equaction that I could use in cells X through AI? I would appreciate your help!
Thanks
Bookmarks