Sample code:
CASE(
MOD(TODAY() - DATE(1900, 1, 7), 7),
1, 'Sunday',
2, 'Monday',
3, 'Tuesday',
4, 'Wednesday',
5, 'Thursday',
6, 'Friday',
'Saturday'
)
Cheers!!!
CASE(
MOD(TODAY() - DATE(1900, 1, 7), 7),
1, 'Sunday',
2, 'Monday',
3, 'Tuesday',
4, 'Wednesday',
5, 'Thursday',
6, 'Friday',
'Saturday'
)
Cheers!!!
No comments:
Post a Comment