Workday function and Gantt chart

Question

Hi,

I wonder if someone could help me with something. Using the WORKDAY function and conditional formatting, I've created an auto-populating Gantt chart in Excel. It all works fine, except that because of the way the WORKDAY function works, each task is a day longer than it should be.

For instance, if I have task 1 starting on 03/10/2011 and enter "2" in my "Days duration" box, I get a task that's three days long. It spans 3, 4 & 5 of October. I can get around this by using the following formula:

=WORKDAY(start date,days,[holidays])-1

I imagine you're way ahead of me on this, but the problem then is that some tasks fall on dates that aren't working days (Monday minus 1 is Sunday).

Can someone recommend a solution for this problem? If anyone can help, I'd be really grateful.

Many thanks

Karl

Answer 1

How about:

=WORKDAY(start date,days-1,[holidays])

Answer 2

That looks perfect and I am abashed not to have thought of it myself. 

Thank you very much!