I have tried with all my knowledge to try and figure this out but with no success.
Scenario.
March has 31 days in the month (this would be entered into the alllocated cell)
We do not work Sundays so less 5 Sundays (this would be entered into the alllocated cell)= 26 Working days.
Last Cash-up complited was on the 20th of March.(this would be entered into the alllocated cell)
Avererage turnover per day is $1350.00 (This amount would be pulled from an allocated cell)
Result should be the following.
31-20(last cash-up day enteted)-2(two non working days left in month)=9
9 x $1350 = $12,150.00.
I have been using =((EOMONTH($D$45,0)-$D$45)-B47)*(1350)
D45 = last cash-up day (20)
B47 = Number of non working days in month(5)
Result is obviously $8,100 and not % 12,500 as it should be.
I have no idea how to work backwards for sundays or count how many Sundays in month and subtract how many are left or have past.
Please assist.

Scenario.
March has 31 days in the month (this would be entered into the alllocated cell)
We do not work Sundays so less 5 Sundays (this would be entered into the alllocated cell)= 26 Working days.
Last Cash-up complited was on the 20th of March.(this would be entered into the alllocated cell)
Avererage turnover per day is $1350.00 (This amount would be pulled from an allocated cell)
Result should be the following.
31-20(last cash-up day enteted)-2(two non working days left in month)=9
9 x $1350 = $12,150.00.
I have been using =((EOMONTH($D$45,0)-$D$45)-B47)*(1350)
D45 = last cash-up day (20)
B47 = Number of non working days in month(5)
Result is obviously $8,100 and not % 12,500 as it should be.
I have no idea how to work backwards for sundays or count how many Sundays in month and subtract how many are left or have past.
Please assist.