I need a formula to show month as Month (i.e. March) instead of # (i.e. 3)

In this board, we are tracking donations. I added the donation date and I need a hidden column to show the Month as Month and not as # from the donation date. This column will be used to form a chart. The formula I am currently using is MONTH({Donation date}) but this shows March as 3. Please let me know if you have any questions that will better help figuring out this formula. Thank you!

Hi @Sydney_Alma - while there may be a more efficient way to do this a simple SWITCH statement does the trick:

SWITCH(MONTH({Donation Date}),
1,“January”,
2,“February”,
3,“March”,
4,“April”,
5,“May”,
6,“June”,
7,“July”,
8,“August”,
9,“September”,
10,“October”,
11,“November”,
12,“December”,“”)

Thanks,
Mark

Hi @mark.anley

While it does work in a board, it will not work if mirrored. Here is a Loom video to show you what is happening and what I am trying to do. I hope this helps explain what I am trying to achieve.

Thank you,
Sydney

@Sydney_Alma

This might help:
FORMAT_DATE({Donation Date},"MMMM")

2 Likes

is there a way to have the month show but off of the Due date. For instance if something is due by Sept 9th, the month would show august?

@Southernbks

Try this:
FORMAT_DATE(EOMONTH(FORMAT_DATE({Due Date}),-1),"MMMM")


Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

1 Like