Hello All -
Attached is my attempt at customizing a Simple Gantt Chart.
I have the Start and End Days for a project. I am experiencing issues adjusting the conditional formatting to exclude Sat and Sun.
Additionally, I would like to integrate a cell on each project line to choose whether or not to include just Saturday in the CF shading.
It's for landscaping projects, and rain days happen.
Thanks in advance.
-steve
Not sure which CF you need to ignore Weekends on...
Assuming it's the blue one.
Formula should be...
Weekday(date,2) will return 1 to 5 for Mon to Fri. So if 6 or 7 is returned, it's Sat, Sun.
Please Login or Register to view this content.
To include Sat for project line. Can be tricky. If project line spans more than one Sat, does it include both? Or just one?
If project line never spans 2 Sat... you can add condition like... (use whatever cell that you'd use to include Sat, instead of $M8).
Please Login or Register to view this content.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
Hello CK - Thanks for your reply.
But...
It is not working on my end. It is filling in the Saturday.
I edited the Rule for the Blue Fill (you were correct) and the result is not correct.
I also cleaned up my Start and End Date Calculations and I do not understand why this update affects the Rule as it does.
The attached sheet is with these changes.
Thanks again!!
I am confused. Your Saturdays are not filled when I open your file.
Attachment 845736
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks