When calculating months within a formula:

cell A7 contains the date "06/03/2020"

Using a formula in cell H20... to display the number of the month, the formula would be:

returning the value of the month, which is the number "6". If you then try to use the text formula:

to change this number into a date, Excel sees the value as a "1" and defaults to "January".

However, when you want a number of a month to be changed to a name, then you would use THIS formula:

- =text(1*29,"Mmmm") or =text(a7*29,"Mmmm")

It is therefore an analytical jump to the following formula:

- =text(month(a7)*29,"Mmmm")

which returns "June". Now, if you wanted to manipulate the formula to show a different month (previous or following),

you would simply add a "+" or a "-" after the month:

NOTICE that you have to parenthesize "Month(A7)" first for Excel to understand that you want that value calculated with

the "1". To now tweak the formula to display the month, the text formula would evolve to:

- =TEXT(((MONTH(A7))-1)*29,"Mmmm")

Parentheses and punctuation are how computations are recognized in a computer, and although frustrating at times, have to

be 100% correct for the logic to be understood.