Formula Help: Financial Liquidity Calendar

[brk004]

Hi,

I work for a college endowment and am creating a spreadsheet/calendar that has all of liquidity terms for our different funds. The idea is to use the =TODAY function to have the spreadsheet be responsive and continuously be current. I'd love your help in developing a formula that will continuously update the sheet and have the output reflect business days and not weekend days.

For example, for Fund 1 there is a quarterly liquidity in which we can only redeem on say 12/31/2017. However, we need to provide 45 days advance notice and so the latest we could notify Fund 1 for a quarterly redemption is 11/15/17 (i.e. 12/31/2018 - 45). Well, November 15, 2017 has passed and so I'd like the formula to recognize that 11/15 has passed and move the next Trade Date to 3/31/2018 and have the Minimum Notification Date be 45 days after which equates to 2/14/2018 (3/31/2018 - 45 days).

And for Fund 3, once 2/12/2018 has passed, the right most cell would need to show 3/31/2019.

Plus, if there's a formula or condition that would ensure that the Minimum Notification Date falls on a workday vs. a weekend that would be very helpful. Once the "code is cracked" this should be applicable to all of the funds.

Many thanks for giving this a look over.

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Fund[/TD]
[TD]Term[/TD]
[TD]Advance Notification (Days)[/TD]
[TD]Minimum Notification Date[/TD]
[TD]Trade Date[/TD]
[/TR]
[TR]
[TD]Fund 1[/TD]
[TD]Quarterly[/TD]
[TD]45[/TD]
[TD]11/15/2017[/TD]
[TD]12/31/2017[/TD]
[/TR]
[TR]
[TD]Fund 2[/TD]
[TD]Quarterly[/TD]
[TD]45[/TD]
[TD]11/15/2017[/TD]
[TD]12/31/2017[/TD]
[/TR]
[TR]
[TD]Fund 3[/TD]
[TD]Annual, only on March 31[/TD]
[TD]45[/TD]
[TD]2/12/2018[/TD]
[TD]3/30/2018[/TD]
[/TR]
</tbody>[/TABLE]