Sales On Par Pace Based on QTD

[B21]

Hello all,
long time lurker here. Im needing a little help calculating a sales pace based on current date within the specific quarter we are currently in.

Currently this is what I am using for Month to Date Pace, but I am struggling to convert this to Quarter to Date.

Book1
	A	B	C	D
1	MTD	GOAL	Today's Date	On Par Pace
2	$2,492.37	$4,000	6/16/21	$2,181.82
3	$16,878.05	$28,600	6/16/21	$15,600.00
4	$1,854.60	$15,000	6/16/21	$8,181.82
5	$10,120.94	$14,000	6/16/21	$7,636.36
Sheet1

Cell Formulas
Range	Formula
D2:D5	D2	=(B2/NETWORKDAYS(DATE(YEAR(C2),MONTH(C2),1),EOMONTH(C2,0)))*NETWORKDAYS(DATE(YEAR(C2),MONTH(C2),1),C2)

 

[Tetra201]

See if the following formula works for you:

=B2/NETWORKDAYS(DATE(YEAR(C2),CEILING(MONTH(C2),3)-2,1),DATE(YEAR(C2),CEILING(MONTH(C2),3)+1,0))*NETWORKDAYS(DATE(YEAR(C2),CEILING(MONTH(C2),3)-2,1),C2)

 

[B21]

This works perfectly! Thank you so much Tetra201! You absolutely saved the day for me!

 

[Tetra201]

Glad to have helped.