Ben Hamilton

Add 2 Years to Date in Excel

I wanted to add two years to a date in Excel. This is the formula you need Hat tip to www.mrexcel.com, assuming your original date is in column A. =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

Posted in How to | Tagged | Comments Off on Add 2 Years to Date in Excel

Excel DATEVALUE Function

When a Microsoft Excel spread sheet has a column of date data in this format: Nov 24 1995 Then the Excel function you’ll find useful is DATEVALUE DATEVALUE function. This formula here: =DATEVALUE((TRIM(MID(R2,5,2))&”-“&TRIM(LEFT(R2,3))&”-“&TRIM(RIGHT(R2,4))) Basically grabs the Day, then the Month, then the Year from the column, then converts it to a serial number that Excel […]

Posted in General | Tagged | Comments Off on Excel DATEVALUE Function

Convert multiple Microsoft Excel files to .csv files with 3 clicks

I often get given Microsoft Excel files to import them into a database. Normally we’ll work with the files in the Excel to clean up data (phone numbers, Addresses, Titles, etc) but then save them as .csv files to do the actual import. On my MacBook this is now an easy task because I’ve setup […]

Posted in How to | Tagged , , | Comments Off on Convert multiple Microsoft Excel files to .csv files with 3 clicks

Excel formula to convert minutes into Hours and Minutes

On occasion I end up with an Excel spreadsheet that has a list of items, each of which has a duration. It’s easy to sum up the minutes and get a total number of minutes (see B7 in the picture below). But it would be nice to see that in “x hours y minutes.” don’t […]

Posted in How to | Tagged , , | Comments Off on Excel formula to convert minutes into Hours and Minutes

Excel Print Management

Over at Chandoo.org’s “Become AWESOME in Excel” blog, a great post on making the printing of reports from large Excel spreadsheets much easier: Printing multiple pages with different layouts using Excel.

Posted in How to | Tagged | Comments Off on Excel Print Management

Export ACT! reports to Excel

Had a client today need some information out of ACT!, and ideally it would be in an Microsoft Excel spread sheet. Given that one of the default ACT! reports gave the bare minimum required (Group Membership) we spent some considerable time editing a copy of that report to display the actual fields we wanted, both […]

Posted in ACT! | Tagged , , , | Comments Off on Export ACT! reports to Excel