Does anyone know an excel macro for settlement date which skips the weekends. For example: ----------Trade Date-------Settlement Date row1-----24.09.2010---------29.09.2010 row2-----20.09.2010---------23.09.2010 Settlement date is T rade Date + 3 day but macro should distinguish between row1(which skips the weekend) and row2(which does not have a weekend)
use workday function eg workday(tradedate, 3) which will be third workday from trade date
Thank you very much:)