In Excel, I want to be able to enter a date in one field and have a date that
is 1 year later in the field next to it; what formula may I use to achieve
this?

Also, if the resulting date is past, how do I make the date turn red?

And, if the first date is 8/30/2008, how do I make it that it turns Green
when we are three months before this date?
--
AjaminB