# Can we Pull Week of the Month?

Member

Hi There,

I need week number of the month, as in Domo I don't find any inbuilt function for this like WEEKOFYEAR.
For Instance :
Spend for week 31 (July 28 to August 3) is \$100,
I want two rows coming under each month and the week for july should be 5 and its spend of only july dates and for august Week should be 1 and has only augusts date spend.

Let me know if there is any calculation that can help me on this.

Thanks

Tagged:

• Contributor

FLOOR((DAYOFMONTH(`datecol`) - 1) / 7) + 1

may do what you are looking for.

• Coach
edited August 12 Answer ✓

As Jones01 says, either of these should work

```FLOOR((DAY(`date_column`) - 1) / 7) + 1
FLOOR((DAYOFMONTH(`date_column`) - 1) / 7) + 1
```

Create a Table or Chart in Domo.

YEAR(date_column)
MONTH(date_column)
Week Number of Month as shown
Total Spend: SUM(spend_column)

** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **

• Coach

@Mukhilan I'd suggest calculating the "Week of Month" using the Calendar dataset from the Domo Dimensions Connector, then joining by date into your spend dataset

• Contributor

FLOOR((DAYOFMONTH(`datecol`) - 1) / 7) + 1

may do what you are looking for.

• Coach
edited August 12 Answer ✓

As Jones01 says, either of these should work

```FLOOR((DAY(`date_column`) - 1) / 7) + 1
FLOOR((DAYOFMONTH(`date_column`) - 1) / 7) + 1
```

Create a Table or Chart in Domo.