Simple formulas for sales target vs working days

[les361800]

Good morning.

Could someone possibly write me a couple of formulas that calculates a sales target depending on what day of the month it is? But one that only counts working days? (not sat/sun)

So the first: works out what money we should be sitting on at that date in the month - based on a target of 180k vs working days

The second: works out what % this figure is of the required target for that day in the month.

I've worked it out manually and put these in red so it makes sense.

Thank you

 

[etaf]

not sure i understand your numbers

on the 2nd working day of the month
and there are 22 working days in aug
8181 is 1 working day for that month

so do you not count the day thats actually shown in date field

Book5
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	date	target	target to date	actual	percent				startdate	enddate		working days	working days in month		1 day
2	8/2/24	180000	16363.6364						8/1/24	8/31/24		2	22		8181.81818
Sheet1

Cell Formulas
Range	Formula
C2	C2	=(B2/M2)*L2
I2	I2	=DATE(YEAR(A2),MONTH(A2),1)
J2	J2	=EOMONTH(A2,0)
L2	L2	=NETWORKDAYS(DATE(YEAR(A2),MONTH(A2),1),A2)
M2	M2	=NETWORKDAYS(DATE(YEAR(A2),MONTH(A2),1),EOMONTH(DATE(YEAR(A2),MONTH(A2),1),0))
O2	O2	=B2/M2