3 Replies Latest reply on Apr 29, 2013 12:43 PM by Shawn Ramsey

# Is there a way to determine 1-4th/5th Weekday of the month?

I am looking at Church donations given by month and I want to see if there are patterns based on the week of the month (ex. fist week of the month vs. middle). I know that it would be difficult because weeks start on different days every month, but since I'm really just interested in Sundays I thought it may make it a little easier.  But I still don't know how to do that, any ideas?

• ###### 1. Re: Is there a way to determine 1-4th/5th Weekday of the month?

I believe this formula INT((DAY([wrkld_dt])-1)/7)+1 in a calculated field should give you what you are looking for.

• ###### 2. Re: Is there a way to determine 1-4th/5th Weekday of the month?

Thanks Shawn, that worked great.

• ###### 3. Re: Is there a way to determine 1-4th/5th Weekday of the month?

It would be cleaner if Tableau would offer a couple additional functions:

• Div function - They have Mod, but no Div (or in Excel Quotient)
• Floor function - I had to use INT to accomplish it (but that does not read as clearly)
• Ceiling function - If you have a floor you need a ceiling