You can try below steps:
current month flag
[current month flag]=TRUE AND [2 weekdays]>=2 and ([day name]<>'Saturday' AND [day name]<>'Sunday')
You can use "Flag" on filter shelf and select "TRUE".
Thanks for your response. In my instance, I need Record 3 to be true because although it's created on a Weekend Day it would still be counted because there has been at least 2 weekdays between the date and today's date.
Your "2 weekdays?" calculation is the most useful but I need to incorporate logic that counts only weekdays and this seems to count all days.
Anything you can add to that specific calculation that would result in ex. Record 1 = 1, Record 2 = 11, Record 3 = 6, record 4 = 1?
Can anyone help here? The calculation I am using is not working for me.
Again - I'm trying to create a calculation that will only count records with a Created Date equal to or greater than 2 weekdays in the past. So for instance, today is Monday, Oct 29 - only records created on Thursday, Oct 25 or before this date would be included.
NVM I figured it out on my own. In case anyone is interested, see below.
IF ((DATEDIFF('day',[Created Date],TODAY()) -
(7-DATEPART('weekday',[Created Date])) -
) / 7*5
+ MIN(5,(7-(DATEPART('weekday',[Created Date]))))
-1) >= 2 THEN 1 ELSE 0 END
Then Sum the field