Reply to thread

Message: [QUOTE="Brian, post: 3837521"] 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. [/QUOTE]