Displaying previous month titles from one inputed date

Hi there,

See if the date formulas in the attached help.

Kind regards,

Robert

Hi Jase,

As the EOMONTH function is a part of the Analysis Toolpak, you need to ensure it's loaded for it to work. To do so, follow these three steps:

1. From the Tools menu, select Add-Ins. Excel displays the Add-Ins dialog box
2. Make sure the Analysis Toolpak check box is selected (ticked)
3. Click OK

Hope this solves the issue.

Robert

Hi Robert, it works but...
Is there another way that doesn't need the analysis toolpack enabled? as I am sharing this sheet with a lot of people to use.
Thanks again

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