Hello - 

I'm building a sales dashboard from a data set comprised of invoice lines. Columns include things like date, invoice#, customer, sku, quantity, price, invoice_total, & customer_address. 

My dashboard shows stats for the current month like MTD revenue and number of unique customers. I'd like to have a dial widget that shows how many business days have elapsed in the current month and how many total business days we have in the current month.

To try to solve this I've created four formula columns as follows:

start_of_month: subdate(current_date(),day(current_date())-1)
end_of_month: end_day(month,current_date())
business_days_elapsed: business_days( "start_of_month",current_date())+1
business_days_total: business_days("start_of_month","end_of_month")

Then in my dial widget I put business_days_elapsed and business_days_total. This seems to work except that it's in UTC so at 4pm PST (my local time) the elapsed_business_days increments. 

Am I going about this the right way? If so how can I get it working in my local time zone?