=TEXT(B1, "dddd") In the above formula, B1 is the cell’s address containing the date. Your Excel sheet may have a different address. The next step is to format the date only in the DD format.

Here's how to find your way around and get the most out of Excel 2007 ... Word 2007 Cheat Sheet; Excel 2007 ... you’ll be up and running — and quite possibly loving the new Excel — in no time.