=VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MON TH(date)-6, MONTH(date)+6))
Creating a worksheet with a graph that reflects nationality of visitors to a
lodge. As you type the Month at the top of the worksheet, the graph reflects
the said month. Previous example commenced season in July with above formula.
So, if you type in July 05, the graph reads from the 1st column and July is
chartered. Type Dec and a graph for december is reflected.
I need to alter to commence season in June, and not July but now graph is
not reading correctly. How do I alter formuala or spreadsheet that season
now commences in June of the year?