=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.

When I’m working in Excel, I sometimes have trouble remembering a formula. Is there an instant crib sheet I can refer to? I know I can look it up in Help , but that’s such a slow process. A. Yes, ...

Conditional formatting is one of the best hacks in Excel, as it lets you highlight key data, making it easier and faster to analyze your sheet at a glance.It typically comes in handy when you need ...

If you need a refresher, see our Excel 2010 cheat sheet. As in Excel 2013, ... head to Microsoft’s helpful “6 new Excel functions that simplify your formula editing experience” post.

Mathematical and logical operations can be performed on a Microsoft Excel workbook with the help of formulas. One of the most common uses of Excel is to compare rows of data by using an IF statement.