This formula will count the number of occurrences of a given single character within a text string in a single cell. This formula is case sensitive and will consider upper and lower case letters to be different characters.

This formula will return the last day of the month from the date selected.

This formula will return the sheet name of the current sheet.

This formula will return the first name with proper capitalization from an email address of the form firstname.lastname@company.com

In a previous post I showed How To Turn A Table Into A Column Using Formulas,...

[button link="https://drive.google.com/open?id=0ByEvd0vhZtF3WTQyQ0pqNTVEVVU"...