NetWorkDays Broken out by Month various Start and End Dates

[Grimm127]

Hello All you wonderful Guru's,
I am stuck on something and I need some guidance.
I have a set of projects that have a number of different start and end dates. So its pretty easy to get total of number of days using the Networkdays function.
The problem I am having that I need to break out the number of days by month.

Also if a Start Date is less than 01.01.2022 it needs to return 01.01.2022 as well as if the End date is greater than 12.31.2022 it needs to return 12.31.2022.
Any suggestions to make this work? I am all out of ideas....

 

[BSALV]

this was almost the same problem, so the solution is equal

Spread Number of Days Worked Equally Throughout Period of Time

HI, I have rejigged a Table I previously used to Spread an Amount equally over a 12 Month Period. This was for ££££. I am now trying to repurpose this to be able to spread a set number of expected work days (1-330) across a set period of months (1-18) See example The issue I am having is that...

www.mrexcel.com

 

[Grimm127]

this was almost the same problem, so the solution is equal

Spread Number of Days Worked Equally Throughout Period of Time

HI, I have rejigged a Table I previously used to Spread an Amount equally over a 12 Month Period. This was for ££££. I am now trying to repurpose this to be able to spread a set number of expected work days (1-330) across a set period of months (1-18) See example The issue I am having is that...

www.mrexcel.com

WOW! Thank you! I never considered the Max, Min. I kept using the greater or less than. It is perfect and works great. Thank you so very much!