Formula to display each month and year of biennium
I am needing help with a formula to display the text month and year or the numeric month and year of each month of a biennium. I am currently developing a "template" metric sheet that will pull data from a report containing various months from the biennium. From this a dashboard will be developed.
The metrics sheet contains a date column where the user will select the first day of the biennium, July 1st.
The column headers are named Month1, Month2, Month3, ... Month24.
For reviewing the metrics sheet there is a row to display the month and year for each column. See image below. I have the formula developed for the first month and year to display. I would like to develop a formula which would be based on either the first month and year displayed or on the BienniumBeginDate so I can drag it across the row to be used for the remaining 23 months. In Excel, depending on your preference of functions it could be written as =TEXT(EDATE(B2,1),"mmmm yyyy")
I have reviewed a number of similar requests, but most are adding several months or involve helper columns. I have tried adapting but have not been able to figure this out.
Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!