Filtering out between Monday and Friday of current week
Content
I want to pull candidates who were moved into specific main statuses only between the Monday and Friday of the current week, inclusive.
I'm new to expressions so I'm a bit lost, but I know what functions I would use in Excel to figure those dates.
- Monday's date = IF(AND(TODAY()>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()) + 2-WEEKDAY(TODAY())),TODAY()<=IF(WEEKDAY(TODAY()+2, 2)<>7,TODAY()-WEEKDAY(TODAY()+2, 2),TODAY())),"YES","NO")
- Friday's date = IF(WEEKDAY(TODAY()+2, 2)<>7,TODAY()-WEEKDAY(TODAY()+2, 2),TODAY())
From these two dates I want to have an expression that let's me filter only the dates that fall between these two.
0