Monthly Archives: July 2011

Finding someone’s age from their date of birth

Using Excel and need to find someone’s age from their date of birth? There is a function not readily documented by Microsoft, called DATEDIF, which will do just that. Say the person’s date of birth is in cell B2, then … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013 | Tagged , | 1 Comment

Pinning files to the recently used list (Office 2007 and 2010)

When you click the Office button in Office 2007, you will see a list of recently used files. To keep a file in the list indefinitely, click on the pin to the right of the filename. It will turn green … Continue reading

Posted in Microsoft Office 2007 and 2010 | Tagged , , | 1 Comment