Recent content by jaredall

This method is usually convenient, but it also is a bit quirky in dealing with months of differing lengths. For example, =DATE(YEAR(A1),MONTH(A1)+2,DAY(A1)) will return 3/2/08 for the input of 12/31/07. If I add 2 months to 12/31/07, I would hope to get 2/29/08. Whatever solves the issue most...

Try the EDATE function in Excel. You will need to have installed the Analysis ToolPak add-in. You can look up EDATE's use in the Excel help file. The function will account for different numbers of days in months and for leap year. For example, EDATE(1/31/08,1) will return 2/29/08. It will...