Completed and remaining days count based on the dates range

**krjoshi** · 11-21-2011, 10:22 AM

Hello,

Does anyone know how to count (Formula) completed and remaining days based on dates range. I have attached a file of what I'm trying to accomplish. Thanks in advance for your expertise!

Joshi

**darkyam** · 11-21-2011, 12:50 PM

In E1, =D2-B2. In F1, =C2-D2. In G1, =NETWORKDAYS(B2,C2,I2:I3) where I2:I3 have holidays listed (this can be expanded as necessary). I'll leave you to figure out H1.

**krjoshi** · 11-21-2011, 01:44 PM

Hi darkyam,

Thanks for your reply. Its working for first two columns (E2 & F2) but for columns G2 and H2 the fraction is not getting (eg. 26.4). Please help.

Thanks in advance.

Joshi

**darkyam** · 11-21-2011, 01:59 PM

Assuming you want your fraction based on an 8 hour day, you can use =NETWORKDAYS(B2,D2,I2:I3)-1+(MOD(D2,1)-MOD(B2,1))*3. If it's not an 8 hour day, you'll have to adjust the *3 (used to translate a 24-hour day into an 8-hour one, so the number needed is 24/#ofHours).