I need to get the IMM dates in excel.

IMM dates are defined as the third Wednesday of every March/June/September/December.

  • 1
    $\begingroup$ You need to get the what? $\endgroup$ – Bob Jansen Aug 1 '13 at 10:08
  • $\begingroup$ Please read your question again, you just forgot to write the most important part of it. $\endgroup$ – SRKX Aug 1 '13 at 13:31

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


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.