Hi!
I'm currently having a bad cold, and my brain cannot function 100%, but I need to get some things done before Friday and I'm losing my mind over something that seems simple: having a formula that counts for each year of a given contract, how many days (both normal days and workdays) a site will be open.
Ex:
Contract start-up date 01.09.2018
Site Start-up date End date
A 01.09.2018 31.08.2023
B 01.09.2018 31.03.2021
C 01.12.2019 31.08.2023
Year 1 is from 01.09.2018 to 31.08.2019 (so site A and B get 365 days while Site C gets 0)
Year 2 is from 01.09.2019 to 31.08.2020 (so site A and B get 365 days while Site C gets less) and so on and so forth
I attached an example of what I'm looking for. With my trials included... Oh boy, did I try...
Thanks for helping me!
Kind regards,
Vincent
Bookmarks