I think I have posted this in the beginning of January. Normally the Expiry is on the Last Thursday of the month. Since 27-Feb is a holiday the FEB-14 Expiry will be on 26-FEB, which you have to change manually.
1. Goto Sheet SODATA.
2. The Cells AP20, AP21 and AP22 contains the expiry for the next three months including the Current month. The dates are automatically calculated using a function
3. Change the date 27-FEB-14 to 26-FEB-14. Leave the Rest of the dates as it is.
4. After 30-Jan-2014, the Dates would once again shift and you will have to do this change once again.
1. Goto Sheet SODATA.
2. The Cells AP20, AP21 and AP22 contains the expiry for the next three months including the Current month. The dates are automatically calculated using a function
3. Change the date 27-FEB-14 to 26-FEB-14. Leave the Rest of the dates as it is.
4. After 30-Jan-2014, the Dates would once again shift and you will have to do this change once again.