Hi,
I have a forumula that currently it looks at cell J9, decides if it is a criteria says EAD or EFM, and then if EAD calculates 30 working days, if EFM counts 30 calendar days and gives me the date.
This is my current formula,=CHOOSE(MATCH(J9,{"EFM","EAD"},0),J11+30,WORKDAY(J11,30))
I need to amend this formula so that it does not include the list of bank holidays I have in a sheet called "Bank Holidays" in column A.
Do you know what the formula should be amended to?
Thanks
Nath'
Have you looked at the NETWORKDAYS function?
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.
When I change the formula to Networkdays it leaves me with a list of ##############.
Attach a sample workbook (not image).
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.
Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
You probably didn't configure it correctly. I asked if you had looked at it - I did not suggest that you simply stick it into the formula and hope for the best.Originally Posted by K-Linerz
As John says, attach your workbook.
If you just want to exclude the holidays from the WORKDAY calculation you can use the same formula but just add the holiday range in to the WORKDAY function, e.g.
=CHOOSE(MATCH(J9,{"EFM","EAD"},0),J11+30,WORKDAY(J11,30,'Bank Holidays'!A$1:A$100))
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks