# How to get the month name instead of month number

**URL:** <https://forum.seatable.com/t/how-to-get-the-month-name-instead-of-month-number/7021>\
**Category:** Formulas\
**Created:** [October 15, 2025, 2:52pm UTC](https://forum.seatable.com/t/how-to-get-the-month-name-instead-of-month-number/7021 "2025-10-15T14:52:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dwright](https://forum.seatable.com/letter_avatar_proxy/v4/letter/d/4af34b/32.png) [@dwright](https://forum.seatable.com/u/dwright)\
**Post date:** [October 15, 2025, 2:52pm UTC](https://forum.seatable.com/t/how-to-get-the-month-name-instead-of-month-number/7021/1 "2025-10-15T14:52:26Z")

</div>

how do i convert the month number to month name in a formula - right now its \<month({Date1}) \> it gives me the month but in number format and I need text January, February, etc.?

---

<div class="post-metadata">

**Author:** ![rdb](https://forum.seatable.com/user_avatar/forum.seatable.com/rdb/32/1869_2.png) [@rdb](https://forum.seatable.com/u/rdb)\
**Post date:** [October 15, 2025, 7:30pm UTC](https://forum.seatable.com/t/how-to-get-the-month-name-instead-of-month-number/7021/2 "2025-10-15T19:30:31Z")

</div>

Please use the switch() function.

> switch(weekday({Date1}), 1, “Sunday”, 2, “Monday”, 3, “Tuesday”, 4, “Wednesday”, 5, “Thursday”, 6, “Friday”, 7, “Saturday”, “no match”)

---

<div class="post-metadata">

**Author:** ![Julia](https://forum.seatable.com/user_avatar/forum.seatable.com/julia/32/2182_2.png) [@Julia](https://forum.seatable.com/u/Julia)\
**Post date:** [October 22, 2025, 6:51am UTC](https://forum.seatable.com/t/how-to-get-the-month-name-instead-of-month-number/7021/3 "2025-10-22T06:51:22Z")

</div>

> [@dwright](#):
>
> I need text January, February, etc.?

Yes, you can use switch() function to get month name. This is my example:

```auto
switch(
  month({time}),
  1, "January",
  2, "February",
  3, "March",
  4, "April",
  5, "May",
  6, "June",
  7, "July",
  8, "August",
  9, "September",
  10, "October",
  11, "November",
  12, "December",
  "no match"
)

```

Here is the month result

 ![截屏2025-10-22 14.49.47](https://forum.seatable.com/uploads/default/original/2X/f/f732e97998b46b87b1ce2871c72b5023b205175a.png)

---

<div class="post-metadata">

**Author:** ![system](https://forum.seatable.com/uploads/default/original/1X/04603423fe81a46c321283663086c475429e8ccb.png) [@system](https://forum.seatable.com/u/system)\
**Post date:** [October 24, 2025, 6:51am UTC](https://forum.seatable.com/t/how-to-get-the-month-name-instead-of-month-number/7021/4 "2025-10-24T06:51:54Z")

</div>

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.