I need to get the IMM dates in excel.
IMM dates are defined as the third Wednesday of every March/June/September/December.
Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. It only takes a minute to sign up.Sign up to join this community
Not sure how you're looking to use it, but if you start with an IMM date in cell A1 (e.g. 9/18/2013), in cell A2 put...
=DATE(YEAR(A1), MONTH(A1) + 3, 1 + MOD(4 - WEEKDAY(DATE(YEAR(A1), MONTH(A1) + 3, 1)), 7) + 14)
...and drag it down. It will return the 3rd Wednesday of the month for every third month, so assuming that the month of the date you put in cell A1 is March, June, September, or December, this will give you what you're looking for.
I modified this answer here from another forum: http://www.mrexcel.com/forum/excel-questions/25668-calculating-every-third-friday.html