Excel in Practice

Instead of managing by a table of dates as shown in Figure 23.58, create a table and link the table with an IF(AND formula, conditional formatting, and a dateline to plot the milestone dates for you. By looking at dates sorted in order of occurrence, you can grasp vast amounts of information with just a glance, as shown in Figure 23.59.