Reference: Calculated Field formulas!

I'm converting this post into a compendium of useful calculated field formulas that do not require any code customization to be effective. Feel free to post some of your own calculated field formulas below (or make the existing ones more efficient) and I'll update the OP.

1) Convert text string to formatted USA Phone Number

It's not pretty, but it'll take up to 17 characters/numbers (even 234///567////8910)and convert it to a standard USA format: +1 (234) 567-8910.

Just copy and paste the below into Notepad, find & replace $phone_work with whatever phone number field you need. Then put it in a calculated field > formula.

This one was awful to test; toString(today()) gives you like 30 characters including a timestamp, even though it's just supposed to be days.

3) Day of the week by name (submitter: Arpad Szabo)

The below formula evaluates a Date field and returns a String of which day of the week that date is on. Copy the below to notepad, find & replace custom_date_field_c with your date field, then paste into a calculated Text Field.