To find whether the record creation Date is Weekday or Weekend it would be simple formula.,
CASE (MOD ( CreatedDate – DATE (1900, 1, 7), 7), 0, “Weekend”, 6, “Weekend”, “Weekday”,NULL)
To find Day of the record creation date use the below,
————————Hope this will help you!——————————-
CASE (MOD ( CreatedDate - DATE (
1900
,
1
,
7
),
7
),
0
,
"Sunday"
,
1
,
"Monday"
,
2
,
"Tuesday"
,
3
,
"Wednesday"
,
4
,
"Thursday"
,
5
,
"Friday"
,
6
,
"Saturday”, “Error"
,NULL)