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.
Select a date 👉
Jan 11, 2023
Reset
MonthName() : The month name of
Jan 11, 2023
is
Month(): Using this formula on my doc gives me this result
MonthName(’MMM’) : The shortened month name of
Jan 11, 2023
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.
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