Hi, sorry for belated response, I'll confess that I can't quite follow the above narrative -- all I can say is that the below:
can be re-written as below - if adding the days on a Mon-Fri basis
so the above would return Thu 31st January rather than Sun 27th January as it will ignore weekends when adding the 9.69* days to the date in R2.
If you want it to add the 9.69* days ignorant of days of week and then ensure it lands on a workday (i.e Mon 28th) you can use
However, I suspect you want the first suggestion?
Bookmarks