Thanks mugezhn, this will take me awhile to digest. I assume I need the 'month' column in all my sheets. Although this formula is still complicated, I assume the advantage over mine is that I only have to make this once, then drag the formula down the column?