Ask Your Question

Revision history [back]

Formula to display "October/November"

I have a sheet with 7 columns, one for each day of the week showing only the day value. I also have a cell which shows the month in text format example "October". I wish that in those weeks which overlap between two months, the value of this cell changes to "October/November".

I managed to write a formula that determines if there's overlap or not =IF(MONTH(C2)=MONTH(O2),C2,1) where C2 is Monday and O2 is Sunday. I am unable to set the value to the combination of the two (with what should I replace the 1 above?).