Working days passed & left in the month / week

[nagesh.tvsr]

Hi,

Would like to get formula for calculating No. of working days passed / remaining for the current week / month.

Excel file attached with relevant details.

Pl. help.

Thanks,
Nagesh.

[pangam_s@yahoo.com]

I Don't Understand month and week concept, but for days please find below formula
No. of working days =NETWORKDAYS(A2,A366,C2:C63)
Working days passed (Excluding today) =NETWORKDAYS(A2,TODAY()-1,C2:C63)
Working days remaining (Including today) =E2-E3

Hope it will work for you.

Regards,
Suhas

[Richard Buttrey]

Does the attached help

Put the 1st day of a month in F2 and a week number in F8

If you wonder why January only shows 24 working days it's because you have listed 3 jan 2015 holidays in C54:C56

[sourabhg98]

Richard it says 24 coz there are 3 more holidays down in the holidays column
I also got confused while preparing the formula...

[Richard Buttrey]

Richard it says 24 coz there are 3 more holidays down in the holidays column
I also got confused while preparing the formula...

Indeed, that's why I mentioned the cells C54:C56 in case the OP was similarly confused.

[nagesh.tvsr]

Hi Richard Buttrey,

Thank you very much, but I have few queries.

Pl. find the file attached with details.

Thanks,
Nagesh.

[samba_ravi]

Is saturday is working?

[nagesh.tvsr]

Saturday is working day. Issue almost solved with Richard Buttrey reply.

Thanks,
Nagesh.

[Richard Buttrey]

Please give some examples of the results you expect for say two different months and two different weeks. i.e. manually add the numbers youj expect to a couple of adjacent columns in the workbook.

[samba_ravi]

See the attached file
Removed the all helper columns (Week Number Columns