Day of Week

Question

I'm trying to find a "day of week" function. Essentially i don't want to count hours on the weekend. Any ideas? It seems like it should just be a formula dayofweek(start()) but i can't find anything like that. Cheers, H

PrevContributor · Accepted Answer

There's a new calculation function due in the 2015.4 release (Oct) which does this; the details are...

"WEEDAY(date, #). This new function has been added. It returns the day of the week (e.g. 1, 2, 3, 4, 5, 6 or 7) based on a date or the current day in a time dimension. By default it assumes that the #1 day is a monday, so WEEKDAY (12/25/2015) returns 5, since it's a Friday. You can decide that the 1st day of the week should be a Tuesday, then you'll write: WEEKDAY (12/25/2015,2) and it will return 4 - Friday is #4 if Tuesday is #1"