Hi, I need to calculate the number of worked days by month. We're in the consulting business so our consultants start and end their mission in the middle of the month.
We have a start date and end date to the mission, and I would like the monthly revenu according to the worked days in the month.
I would have something like :
if the start date is in the month, then the number of day is from the start date to the last day of month. If the end date occures in the month, the number of day is from the first day of the month to the end date.
I then have to take into account the revenue (TJM) and the number of working days in a week (Temp hebdo)
Could you please help.
Thanks beforehand,
Fanny