Hi all,
I'm new to Excel and trying to learn. I'm working on gantt charts to do basic scheduling for a small production machine shop. I'm trying to use the workday function but it isn't working well for me. The problem is that we don't have a typical 2 day weekend, as we have employees work on Saturday as well. This means Sunday is the only time projects are not being worked on. I'm not sure how to get the functionality of the workday function while using only a 1 day weekend. Can anyone help?
Edit: Well of course I solved it as soon as I posted, after struggling for an hour. I used workday.intl.
While I'm here I have another question, I don't want to clutter up the board with posts. So I have a table with all of my data in it, when the job starts, total days to complete, progress/days that have been completed, days left to complete, etc. I am using workday.intl to account for Sundays in my completion dates. But it doesn't graph right this way, because the columns such as progress are numbers, not dates, and they don't take sundays into account... not sure if I'm making sense. If anyone can help, thanks. I chart edit.xlsxhave attached my excel file.
Bookmarks