# PCM Courseware Blog

Posted by Roger Hyttinen on

Microsoft Access 2016 Level 2 is now available for download from the PCM Courseware library. You can preview the first three chapters of each course from our Microsoft Access page. Microsoft PowerPoint courses are forthcoming.

## How to Subtract Dates in Excel

Posted by Roger Hyttinen on

In yesterday’s post, we looked at how to add two dates together in Excel. Today, we going to look at how to subtract dates. If you want to calculate how much time has passed between two dates, you need simply subtract the oldest date from the most recent date. For example, if the value in cell A1 was 12/31/2014 and the value in cell B1 was 9/3/2014, your formula would read: =A1 – B1 The resulting answer would be 4/28/1900 – hardly what we expected. In order to get the correct response, we need to format the cell where the...

## Adding a Date/Time Interval in Excel

Posted by Roger Hyttinen on

One of the most common date calculations used is that of adding together a date and a date interval. For instance, if your customer invoices are due every 30 days, you would find the next due date by adding 30 to the last billing date. To add the number of days to a date, just use basic addition. For instance, if you wanted to add 30 days to today’s date, the syntax would be: =TODAY + 30 Adding Months & Years to a Date If we want to add months or years to a date, the formula becomes a little...

## Make a Backup of your Word or Excel Macros

Posted by Roger Hyttinen on

If you are a heavy Microsoft Word or Excel macro user, you may have experienced this scenario: After a Microsoft Office update, all of your beloved macros are gone. Poof! This has happened to me more than once and now I’ve learned to backup up my macros. This is actually a lot easier than you may think. What I do, is display the code for any of my macros, choose Select All from the menu, copy my macros to the clipboard and then paste the code into an external document. This can be and Evernote or OneNote note, a plain...