I have input the following dates into cells A1,B1,C1,D1 respectively...March
30, 2009, August 20, 2009, July 30, 2008, November 20, 2008. Cell Z1 is
todays date =TODAY() which is August 27.
I would like three formulas as follows:
1) Cell e1 that will count the number of days following the most recent date
of the 4 cells above, in this example the result is "7".
2) Cell f1 that will show a date that is 3 days after the most recent date
of the 4 cells, in this example the result is August 30/09.
3) Cell g1 that will count days based on two criteria: if all of the 4 cells
(a1-d1) are dates in the past, then g1 will add 30 days to the most recent
date and count the number of days from today to that date or if one of the
dates in the 4 cells is a date in the future, then the value in g1 is simply
the number of days from today to that date, in this example the result is
"23".

Thanks very much for your help with this.
--
Brian