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.
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) |