Forum Discussion
Adding Sat/Sun back to Gantt Chart Calendar
normabeez Sorry. Forgot about the fact that the file had been posted already. Took another look at it and made some changes.
The end date is now based on the start date plus the number of days it takes to complete the task. Then I changed the formula in the grid to return zero is the day starts with "S". That will prevent the milestone icons to show. Lastly, I greyed out all Saturdays and Sundays in the grid. Is that what you had in mind?
See attached.
Riny_van_Eekelen Currently I have the following formula in K7:
=WORKDAY(J7,1)
Using your suggestion brings back Sat/Sun to the calendar but it now includes work falling under Sat/Sun. I'm trying to have the work skip over the weekends.
The formula I'm using in J11 is:
=IF(AND($C11="Goal",J$7>=$F11,J$7<$G11),2,IF(AND($C11="Milestone",J$7>=$F11,J$7<$G11),1,""))
Do I need to edit this cell instead to get it to skip Sat/Sun? If so, what changes should it show?
normabeez Difficult to assess. You have tinkered with a not very intelligent template. Personally, I'm not a fan of templates like these. Use them as they are or not use them at all.
Can't really help without having the file in hand. Sorry.
- Riny_van_Eekelen
Appreciate your honesty and I get it. However it was the most convenient option at the moment. I had attached the file in my original post.normabeez Sorry. Forgot about the fact that the file had been posted already. Took another look at it and made some changes.
The end date is now based on the start date plus the number of days it takes to complete the task. Then I changed the formula in the grid to return zero is the day starts with "S". That will prevent the milestone icons to show. Lastly, I greyed out all Saturdays and Sundays in the grid. Is that what you had in mind?
See attached.
- Riny_van_Eekelen Apologies for the delayed response, I was OOO the last few days. Thank you so very much for your assistance! THIS IS PERFECT! Thank you again for your time, it is so very much appreciated!
