Hi, I am trying to create a calendar that shown only working days, but I also want to show the number of days available to complete the project as per the attached file. The dates also need to be included.
Thanks
Malcolm
Hi, I am trying to create a calendar that shown only working days, but I also want to show the number of days available to complete the project as per the attached file. The dates also need to be included.
Thanks
Malcolm
Please manually mock up the sample workbook as you want to see it. Thanks.
This will calculate the number of working days:
=WORKDAY.INTL($B6,$C6,1)-$B6
You can add another condition that will read from a range containing holiday dates if you wish.
Last edited by AliGW; 08-04-2021 at 03:37 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please see the attached file, this is how I want the dates to look
In E5 copied across:
=WORKDAY.INTL(D5,1,1)
Perfect, thanks so much for your help on this, I really appreciate your prompt attention
Did you see my earlier post? There is another possible criterion in WORKDAYS.INTL that allows you to reference a range containing holiday dates that are not covered by weekends.
You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks