This preview shows page 1. Sign up to view the full content.
Unformatted text preview: date. However, a different date could be entered in this cell if you wanted to calculate the "Time Since Sale" using a different date. (see below) In column E (starting in cell E8) create a formula to calculate the Time Since Sale in months. This calculation should use the Sale Date and the Date used for "Time Since Sale" from F4. (Show the number of months to 1 decimal place, and also have the cells show the phrase " mos" after the value for the # of months.) Hint: To summarize the dates by quarter, you'd add the Date field as a Pivot Table row label, then right-click it and choose Group and Show Detail. .., then Group. ... (Excel 2007 may automatically group the dates for you. ..but to change the grouping in Excel 2007, right-click on the Date label in the pivot table table and select Group. ..)...
View Full Document
This document was uploaded on 11/04/2011 for the course BUSI 402 at UNC.
- Fall '10