I'm working on a Gantt chart that extends out 90 days (horizontally) one day at a time from a minimum date in a vertical task range. This is typical of most project management spreadsheets.
What I want is to identify which month that date occurs.
example attached.
In the first column of the Gantt portion, I have a fixed date formated to display the date, that's easy. What I want, then, is automatically populate the cell above the first of the month with the name of that month.
Bookmarks