Excel EOMONTH Function

Excel EOMONTH Function

March 27, 2012

Excel EOMONTH Function

Continuing on from last week’s EDATE function, today we’re looking at the Excel EOMONTH function. If you use Excel to

Read More
Excel EDATE Function

March 20, 2012

Excel EDATE Function

If you need to calculate due dates for projects or payments then Excel’s EDATE function will make life easy for

Read More
INDEX MATCH With a Twist

January 12, 2012

INDEX MATCH With a Twist

My Toughest Excel Challenge So Far! Recently a member contacted me with a VLOOKUP question, but when I further understood

Read More
Excel INDIRECT Function

December 14, 2011

Excel INDIRECT Function

The Excel INDIRECT Function has many applications and perhaps its simplest is to fix a range of cells you want

Read More
Excel TIME Function

September 28, 2011

Excel TIME Function

The Excel TIME function combines separate hour, minute and second values and converts them into a time serial number. If

Read More
Excel Paste Shortcut

September 14, 2011

Excel Paste Shortcut

The other day I was in an Excel forum helping answer some questions. I like to help, because….well, I like

Read More