Hello!
Need some help on creating this excel with WORKDAY formula. Basically, I will need to have an excel that will allow me to punch into some cells and it will give me the Notice dates and Expiry dates
Eg -
1) Roll date = On every 18th
2) Frequency = Every Quarterly (this can be changed to Monthly/yearly/semi-annual)
3) Notice gap - 10 days (refers to working days)
3) Holiday Calendar = LDN (refers to london holiday)
4) Business day convention = following (this takes into month end whereby MF means it will go into the previous day while F means it will go into the first day in next month , eg if I have Roll as 31st and its Monthly, if I have MF here and 31 Oct is a holiday or weekend, it will go back to the previous day (30th - if its a good working day for the above calender)
Expected results -
Expiry dateNotice date
18-Mar-11 4-Mar-11
18-Jun-11 6-Jun-11
18-Sep-11 5-Sep-11
18-Dec-11 5-Dec-11
*above dont take into account any holiday, etc
Thanks!!!
Bookmarks