First Date: How To Format Excel Dates


We all remember that first date... the nervous looks, the awkward silences, and the trusty yawn-and-put-the-arm-around-the-shoulder move (which never worked for me...).

Thankfully, working with dates in Excel for the first time is far easier.  Need to format a date to look different than the default mm/dd/yyyy?

Select the cell(s) you want to look different and click the right mouse button.  From the list of options, you want "Format cells...".

In the Number tab, you'll notice that "Date" is already selected on the left, and the right side provides a whole list of alternate ways to display a date.

Need additional help with Excel dates or other questions?  Contact us now to chat live!