Workday function

Colin Chee

I am trying to use the "Workday" function. It requires the Start date and "duration".I tried to get the duration from the "duration" column of my Gantt chart but because it has a suffix of 'd' for days or 'w' for weeks, the function ends up with an error. It cannot handle that format. So I had to create another column and put =Duration@row which returns the number of working days and then I can refer to that cell. While that works, its clunky. Is there a better way?

Gia Thinh

Hello Colin,

Modify your formula by converting the Duration to a number as below. Hope it works for you.

=WORKDAY([Start Date]@row, Duration@row * 1)

Gia Thinh

Hello Colin,

Modify your formula by converting the Duration to a number as below. Hope it works for you.

=WORKDAY([Start Date]@row, Duration@row * 1)

Colin Chee

Wow! Brilliant! It works like a charm! Didn't know such tricks exist! Many thanks!

Gia Thinh

You are welcome!