I want to have a formula column that just lists the current month of the year. I would assume that just like TODAY(), set the date for today, I could do the same thing with the word month, however it is not working. Any ideas how to have the current month show up in a formula column?
Hi @Tara-Horn,
Try:
SWITCH(MONTH(TODAY()),1,"January",2,"February",3,"March",4,"April",5,"May",6,"June",7,"July",8,"August",9,"September",10,"October",11,"November",12,"December")
Thank you @GCavin !!