This is where the TEXT function is invaluable, because it allows you to force Excel to format the values the way you want by using a format code, like "MM/DD/YY" for date format.

Mar 14, 2012 · Format today's date: =TEXT (TODAY (), "MM/DD/YY") results in 03/14/12 Format a time: =TEXT (A1,"hh:mm:ss AM/PM") where A1 is a time formatted cell and produces results …

Suppose you want to create a grammatically correct sentence from several columns of data for a mass mailing or format dates with text without affecting formulas that use those dates. To …

To convert a text date in a cell to a serial number, use the DATEVALUE function. Then copy the formula, select the cells that contain the text dates, and use Paste Special to apply a date …

You can use the DATE function to create a date that is based on another cell’s date. For example, you can use the YEAR, MONTH, and DAY functions to create an anniversary date that’s …

Let's say you want to see the date displayed for a date value in a cell as "Monday" instead of the actual date of "October 3, 2005." There are several ways to show dates as days of the week. …

Jan 1, 2008 · The DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date. The DATEVALUE function is helpful in cases where a …

Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.

In the Additional Column Settings section, enter the formula that you want to use in the Formula box. For more information on calculated columns and functions, see Calculate data in lists or …

Make sure you surround "ddd, mmmm dd" date format with double quotes, and notice how the format uses commas and spaces. Normally, formulas use commas to separate the …