Our group recently discovered the Gnatt Chart through the myonlinetraininghub.com and are looking to modify the display dates.
Currently the display uses the following
=MIN(D6:D50)+Workings!P2
I have multiple projects that have been active for the past few years that have movement planned in the next few weeks.
I need to have info displayed for what is "In Progress"
Current display will start at the MIN
would it be possible to have the date based on something other than the start of the project listing, and display the current date or a set date range that matters? previous week and next 4 weeks?
8
Hi Chris,
Welcome to our forum!
You can change the starting date formula to something more relevant to you. If you want the previous week and the next 4 weeks then your starting date formula might be:
=TODAY()-7
Mynda