# Basic syntax: =MONTH("Apr"&1) # returns 4 # Where: # - &1 concatenates 1 to the month string allowing it to be recognized # as a date by the MONTH function