Log In
Register
Home
Power Pivot
Excel Expert
August 5, 2021
Offline
Hi
looking a bit of help around a Gantt and building in days to only include 2 weekdays as this is all that will be allocated per week for a project.
do i use the workday.intl or a different formula?, i looked at the workday.intl and it only allows the removal of two days in a week?
hope this makes sense
Jacqui
See Answer
July 16, 2010
Offline
Hi Jacqui,
It depends on whether those workdays are sequential or not. e.g. are they Monday and Tuesday or Monday and Thursday? Also, please confirm that what you're asking for is an automated way to generate a list of dates?
Mynda
Power Pivot
Excel Expert
August 5, 2021
Offline
Hi Mynda
the days are Thur, FRi as a part time worker - just looking for the gantt to reflect the days that are available to work on the project that will be the two days a week, and also hoping to add in holidays as well.
thanks
jacqui
July 16, 2010
Offline
Hi Jacqui,
This formula will give you a list of Thursday and Friday dates where A1 contains the first date you want to start at:
=WORKDAY.INTL(A1,1,"1110011")
Copy down or across as many cells as required
You can add the holidays to the last argument that I have omitted.
Mynda
Answers Post
1 Guest(s)
