=(A2/(DATE(YEAR(TODAY())+1,1,1)-DATE(YEAR(TODAY()),1,1)))*B2
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Percent | Days | Current Percent | |||
2 | 25% | 252 | 17.26% | |||
Sheet1 |
=(A2/(NETWORKDAYS(DATE(YEAR(TODAY()),1,1),DATE(YEAR(TODAY()),12,31))))*B2
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Percent | Days | Current Percent | |||
2 | 25% | 252 | 24.23% | |||
Sheet1 |