Formula to tell day for a given date in Salesforce

Hi kumar,

use this

CASE( MOD( Date__c – DATE(1900, 1, 7), 7), 0, “Sunday”, 1, “Monday”, 2, “Tuesday”, 3,
“Wednesday”, 4, “Thursday”, 5, “Friday”, 6, “Saturday”,”Error”)

hope it may helps