Sample Code:

CASE(
MOD(TODAY() – DATE(1900, 1, 7), 7),
1, ‘Sunday’,
2, ‘Monday’,
3, ‘Tuesday’,
4, ‘Wednesday’,
5, ‘Thursday’,
6, ‘Friday’,
‘Saturday’ )