Workdays are not taken into account for end date values

f105kid / excel-gantt-chart

Automatically exported from code.google.com/p/excel-gantt-chart

0 stars 0 forks source link

Workdays are not taken into account for end date values #1

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago

Hi Wei,

Thanks for the template - very useful!
I've changed the formula for column H to ensure that weekends are not 
calculated. I used the following formula for the row 10:
=WORKDAY(G10,J10-1)

Cheers,
Maksym
http://maxim-dikhtyaruk.blogspot.com.au/

Original issue reported on code.google.com by maxim.di...@gmail.com on 28 Jan 2014 at 5:32

GoogleCodeExporter commented 8 years ago

Hi,

When you change the formula for row 10 to work day the highlights are a bit off.
Any ideas how to fix?

Cheers,
C

Original comment by c.ice...@gmail.com on 16 Jun 2014 at 11:42