Log In
Register
Home
Excel
Word
Outlook
Operations Management
December 16, 2020
Offline
Hi Brains trust,
hope someone can assist, am new to using Excel correctly, am having a complete brain freeze in designing and adding my formulas into my table, the aim of the Dashboard is to create a Gantt chart, see uploaded spreadsheets with current Data set out in a table format.
1. Not even sure if the headings are logical, in summarise there are 2 projects which have multiple tasks assigned, these have been broken down into separate line items to differentiate Task and Duration, sequentially the first task needs to be completed before the second task commences - not sure what the syntax is that I need to use.
2. Have successfully written the syntax in H2 - "End Date" and the column has been populated, however when trying to replicate the syntax for F2 - Task Completed I'm getting an error, I'm using =WORKDAY.INTL([@StartDate]]-1,[@BreakdownTaskDuration]],-1 which it doesn't like and I can't figure out why.
Thanks in advance
July 16, 2010
Offline
Hi Lionel,
The Task Completed Date formula needs the minus before the 1 in the last argument removed for the 'weekend' type, i.e. this:
=WORKDAY.INTL([@[Start Date]]-1,[@[Breakdown Task Duration]],-1)
Should be this:
=WORKDAY.INTL([@[Start Date]]-1,[@[Breakdown Task Duration]],1)
In regards to calculating the Start Date so that the first task is completed before the second task begins, I think you'll need to manually enter these dates.
Hope that helps.
Mynda
Excel
Word
Outlook
Operations Management
December 16, 2020
Offline
Hi Mynda
The solution worked so thank you, its wonderful to have this forum to be able to safely post sometimes "blonde" questions without judgement, something so simple as one wrong character makes all the difference, think i was bog eyed from looking at the problem and couldn't see the mistake.
not sure who Lionel is but if he is having the same problem then am sure it will work for him.
kind regards
Andrea
1 Guest(s)
