DATE and TEXT are what Excel does best.
We use Dates to run a business. Here are some useful formulas to get the DAY, MONTH, and YEAR from a Date.
TEXT functions can combine (CONCATENATE) cells, say a Mail Merge field with first name and last names. TEXT functions can also find just part of the data, perhaps the last two letters.
