MonthName
MonthName
Formulas: MonthName()
Category: Dates/Times
MonthName()Returns the month name of a date
put a bit simpler...
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. 
Select a date 👉
Jan 11, 2023
Reset
MonthName() : The month name of is
Jan 11, 2023
Month(): Using this formula on my doc gives me this result
MonthName(’MMM’) : The shortened month name of is
Jan 11, 2023
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.
Practice: Find the shortened month name of todays date
Done
View upcoming staff PTO more simply and find how many have PTO in each month
Done
View staffs upcoming PTO as a circle graph to view how many staff are out in a different months
Done
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.