I have a date based on which all calculation will occur, known as the Value Date
My Tenor can be either 1,2,3,6 months
For e.g. if the value date is 01.01.2015 and the tenor is 2 months, then 31 days of Jan (Value Date month) + 28 days of Feb will be added to the value date, which will be 1st of March 2014 (Maturity Date)
Uptill here I have it figured out.
If the Value Date is last day of the Month for eg. 28th Feb 14, and the tenor is 1 month, then it should calculate directly to 31st March 2014 (Maturity Date) (Last Days of the next month; Tenor of 1 months added)
I have a list in range A1:A17 that has Holidays (Festivals etc). And apart from those Holidays, all Saturdays & Sundays should be taken as holidays.
So if the Maturity date is coming on a Sunday, it should show the Friday Date (Previous Working day)
I have worked on the problem a bit, Please find attached Excel Sheet for reference.