+ Reply to Thread
Results 1 to 2 of 2

Adding Sat/Sun back to Gantt Chart Calendar

  1. #1
    Registered User
    Join Date
    08-04-2022
    Location
    Florida
    MS-Off Ver
    MS Office 365 Apps for enterprise
    Posts
    11

    Question Adding Sat/Sun back to Gantt Chart Calendar

    Hi All,

    One more Gantt Chart question for everyone. I am using the Agile Gantt Chart template and along the way of my customizing, I lost the Saturday and Sundays on the calendar as seen below.

    PS30Days1.jpg

    Currently I have the following formula in K7:
    Please Login or Register  to view this content.
    I know I'm using WORKDAYS to calculate working weekdays, but I still want to be able to see Saturdays and Sundays - perhaps grayed out instead of entirely gone like the example snapshot below. I tried using WORKDAY.INTL and ended up wrecking it.

    Then I thought maybe I need to change the calendar itself, so the formula I'm using in J11 is:

    Please Login or Register  to view this content.
    Do I need to edit this cell instead to get it to skip Sat/Sun? If so, what changes should it show?

    PS30Days2.jpg

    If anyone has any suggestions, it would be most appreciated!

    PS30Days.xlsx

  2. #2
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,449

    Re: Adding Sat/Sun back to Gantt Chart Calendar

    with =WORKDAY.INTL(J7,1,"0000000") and perhaps as 4th parameter a range with you holidays and conditional format to gray them ???
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. auto fill calendar form excel Gantt chart
    By kriminaal in forum Excel General
    Replies: 7
    Last Post: 03-22-2022, 05:44 PM
  2. Inputting data onto a Gantt chart/Calendar
    By Jfarnish in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2020, 04:00 AM
  3. Adding working days on weekends to a gantt chart
    By Yannis07 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2020, 08:19 AM
  4. Excel Gantt chart to Calendar view
    By kriminaal in forum Excel General
    Replies: 1
    Last Post: 01-26-2017, 03:11 PM
  5. Merge Cells in Gantt Chart to form calendar view
    By jayjacko in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-03-2013, 09:07 AM
  6. [SOLVED] Gantt Chart: unable to set calendar month as x axis ?
    By niciwhite in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-09-2013, 03:53 AM
  7. Adding frills to a Gantt chart
    By ddflip in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-02-2006, 11:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1