A
any
I want to calculate the settlement date(SD) base on the trade date (TD).
Normanly the SD is TD +3 business days. (Skip weekends and holidays)
I set up this calculation:
=IF(OR(WEEKDAY(B341)=2,WEEKDAY(B341)=3),B341+3,B341+5)
This works fine until there is a holiday ( eg. 7/4 and Thanksgiving) in the
period.
Any suggestons?
Thank you.
Iolani
Normanly the SD is TD +3 business days. (Skip weekends and holidays)
I set up this calculation:
=IF(OR(WEEKDAY(B341)=2,WEEKDAY(B341)=3),B341+3,B341+5)
This works fine until there is a holiday ( eg. 7/4 and Thanksgiving) in the
period.
Any suggestons?
Thank you.
Iolani