Formulas: MonthName()
Category: Dates/Times
MonthName()
Returns the month name of a date
put a bit simpler...
Hey Coda, give me the name of the month in this date.
MonthName() has two parameters, one is necessary and one is optional.
DateTime
MonthName(DateTime, Format)
A date/time that you want to add more months to.
Format
MonthName(DateTime, Format)
"MMM" returns a shorthand name; "MMMM" returns the full name.
MonthName() : The month name of is Month(): Using this formula on my doc gives me this result MonthName(’MMM’) : The shortened month name of is As you can see, this formula is rather simple —pass it a date and you get a very predictable result. Don’t pass it up so quickly, though! Month() is really helpful when building graphs or grouping your data.
Try some of the activities out below to see why.