Just a little correction, it should be:
=DATEDIF(A1,TODAY(),"m")5

otherwise it calculates over 7 month, not 6

"Pieter Kuyck" wrote in message
...
Ken,

With Conditional Formatting
Formula Is
=DATEDIF(A1,TODAY(),"m")6
Select a format.. patterns choose a color

Date in A1 will change of color when the date is more than 6 month ago.

Pieter



"kscroggs" wrote in message
...
| I work with Big Brothers Big Sisters and I am trying to
| schedule our evaluations for 6 months after the original
| match is made. Is there a formula that will make the
| dates change color when they go over the 6 month time
| peroid?
| I hope that this does not have to be a macro!!!!!!
| Thank you,
| Ken Scroggs