Displaying previous month titles from one inputed date

Hi Jase,

Though I can't see any issue with having the Analsis Toolpak installed for all users, the attached is another (more clunky) way to achieve the same.

Perhaps hidding Sheet2 (or whatever you name it to) might be a good way to go.

HTH

Robert

Thanks Robert, your solution is almost there but unfortunately, when you put in a Jan Feb or Mar date it returns #N/A, because the formula is trying to subtract 3 from 2 (in the case of FEB) any other ways around it you can think of? Or anyone else?
Thanks again,
Jase