Question: how to calculate month value in excel?
Answer: =TEXT(A2, "mmm") - returns an abbreviated month name, as Jan - Dec.
=TEXT(A2,"mmmm") - returns a full month name, as January - December.