Displaying previous month titles from one inputed date

How do I make three column headers display The previous three months from todays inputed date? SEE ATTACHMENT

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