Hi all, really hoping to get some help with a formula.
I need to set these parameters:
How many working days in between (these two dates) fell in between these two dates.
i.e. How many working days between 10/06/2019(cell a2) and 18/06/2019(cell b2) fell in the period between 15/05/2019(cell d2) and 15/06/2019(cell f2). Looking for the answer 5 in that example.
I hope the above makes sense.
Thanks in advance if anyone can shed any light!!
Last edited by hweld; 07-04-2019 at 11:42 AM.
FYI this is a well known problem hat has been asked and solved many times, be it here or elsewhere
Thanks Pepe, maybe I am searching for the wrong criteria but I am unable to find the answer
The NETWORKDAYS function is what you need to look at.
For anything more specific, please attach a workbook.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks