- Topics: 19
- Replies: 28
- Posts: 47
We have a DAYOFWEEK function that can be used in formulas to specify certain days, where 1 = Sunday and 7 = Saturday. The following would show all -2% returns that occurred on a Friday:
1234 DAYOFWEEK() == 6 andCHANGE()<-2
awesome, I will try it this weekend to see the results.