I want the code for actual mtd to reflect after a certain date I want the reminder of the chart to show 0s. for example if I only want up to June 20th I want every date afterwards to reflect a 0. When I drag down the formula for actual mtd and goal mtd if a 0 is present I don't want it to restart my count.
Date Count of BOL # Actual MTD Goal MTD Actual with Projected Goal Per Day
6/1/2015 28 28 20 28.00 20.00
6/2/2015 30 58 40 30.00 20.00
6/3/2015 24 82 60 24.00 20.00
6/4/2015 23 105 80 23.00 20.00
6/5/2015 28 133 100 28.00 20.00
Sand Tracking SharePoint - Q2 2015.xlsx
Bookmarks