Formula for date on or before last Friday

//try this
var date MyDate = [PAYROLL START DATES];

var number DaysToSubtract = Case(DayOfWeek($MyDate),
0,2,
1,3,
2,4,
3,5,
4,6,
5,0,
6,1);

var date LastFriday=
$MyDate - Days($DaysToSubtract);

If([PAYROLL START DATES] <= $LastFriday,
"RED",
"#FFFFE0")




------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------