Weekday and Weekend Calculation Using Formula Field in Salesforce

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,

CASE (MOD ( CreatedDate - DATE (1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3,"Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday”, “Error",NULL)
————————Hope this will help you!——————————-

Author Bio

Merfantz Editor
+ Recent Posts
Tags:

Leave a Reply