how can I just reference the cell next to it? I mean just add 1 month and make it a 3 rd thursday? You mentioned A1 and the year is in the cell next to it.
hope I make sense.
Thursday, March 21, 2013 Thursday, April 25, 2013
make this one the formula...
pdvsa
ASKER
oh I see now...duh. I was thinking too much into it.
Martin: that worked perfectly. My gosh that looks complicated. Thank you. I think I will ask to reopen question and award points to you.
let me know if there are any objections...
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
My suggested formula calculates correctly, for e.g. it shows 18-April-2013.
I don't know your data structure and how you want to drag the formula. If you want to drag it across, then you will need a date in each column. Or, if you want the formula to increase by one month if you drag it across, then it might be a good idea to actually mention that requirement in your question.
A1 has the start date.
B1 has this formula, which calculates the third Thursday of the month in A1