# MOnth only computed column from date column

**URL:** <https://community.glideapps.com/t/month-only-computed-column-from-date-column/65045>\
**Category:** Ask for Help\
**Created:** [August 15, 2023, 2:23pm UTC](https://community.glideapps.com/t/month-only-computed-column-from-date-column/65045 "2023-08-15T14:23:06Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![John\_Romano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_romano/32/74316_2.png) [@John\_Romano](https://community.glideapps.com/u/John_Romano)\
**Post date:** [August 15, 2023, 2:23pm UTC](https://community.glideapps.com/t/month-only-computed-column-from-date-column/65045/1 "2023-08-15T14:23:06Z")

</div>

how do i extract just the month of the date from a computed column?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 15, 2023, 3:00pm UTC](https://community.glideapps.com/t/month-only-computed-column-from-date-column/65045/2 "2023-08-15T15:00:45Z")

</div>

MONTH(Date) in a math column

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 16, 2023, 8:12am UTC](https://community.glideapps.com/t/month-only-computed-column-from-date-column/65045/3 "2023-08-16T08:12:54Z")

</div>

Just to add to Jeff’s reply, if you’re looking for the name of the month, then see below:

> [@abacus New Math functions](https://community.glideapps.com/t/new-math-functions/16761/64):
>
> Method 1: Use the Format Date column with the MMMM formatting option. Method 2: Add the month names of the year in a single column, one row per month Use a Math column to determine the Month Index number from the date: Month(Date)-1 Use a Single Value column to fetch the month name from your list of months, using N from start where N is the month index. Method 2 requires more effort, but it is more reliable and is guaranteed to work regardless of device/browser/regional date format variati…

---

<div class="post-metadata">

**Author:** ![Nyi\_Nyi\_Soe\_Win](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nyi_nyi_soe_win/32/77894_2.png) [@Nyi\_Nyi\_Soe\_Win](https://community.glideapps.com/u/Nyi_Nyi_Soe_Win)\
**Post date:** [August 27, 2024, 9:37pm UTC](https://community.glideapps.com/t/month-only-computed-column-from-date-column/65045/4 "2024-08-27T21:37:04Z")

</div>

> [@abacus New Math functions](https://community.glideapps.com/t/new-math-functions/16761/64):
>
> from your list of months, using N from the start where N is the month index. Method 2 requires more effo

Sorry Can you please explain more I don’t get N mean or method 2 with some demo

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 27, 2024, 10:47pm UTC](https://community.glideapps.com/t/month-only-computed-column-from-date-column/65045/5 "2024-08-27T22:47:26Z")

</div>

N is the 'N’umber result from the math formula `Month(Date)-1`. It ends up being the month number minus one. That result is used with the single value column to tell it which row in the month name table you want.

For example, it’s August, which is the 8th month. 8 - 1 = 7. This tells the Single Value column that you want the 7th row from the 1st row. Add 7 to 1 and you get 8, which is the 8th row, which contains the month name of August.