Hi I need help to plugin the Workday & Holiday formula to my existing formula to calculate the number of days. =IF(D9="","",IF(F9="",E9-D9+1,(E9-D9+1)-G9)) In above formula: D9 is the start date E9 is the End Date F9 is manual column to calculate the % of work completed and G9 has the formula to calculate the Work Done [=IF(F9="","",(E9-D9+1)*F9%)] H9 is the column where Work Left is calculated What I am looking for is the Work Left (H9) column calculates the total days including weekends. I do not want it to calculate the weekends. Also, I would want that there are certain list of Holidays too which should not be counted too. Please help! Thanks in advance. Best, Rajat

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Combine IF and WORKDAY functions in Gantt

Thread starter rajatsehgal
Start date Jan 11, 2019
Tags

calculate excel help formula if and workday functions work

rajatsehgal

New Member

Jan 11, 2019

Hi

I need help to plugin the Workday & Holiday formula to my existing formula to calculate the number of days.

=IF(D9="","",IF(F9="",E9-D9+1,(E9-D9+1)-G9))

In above formula:

D9 is the start date
E9 is the End Date
F9 is manual column to calculate the % of work completed and
G9 has the formula to calculate the Work Done [=IF(F9="","",(E9-D9+1)*F9%)]
H9 is the column where Work Left is calculated

What I am looking for is the Work Left (H9) column calculates the total days including weekends. I do not want it to calculate the weekends. Also, I would want that there are certain list of Holidays too which should not be counted too.

Please help! Thanks in advance.

Best,
Rajat