Hi!

Select cell A5

Goto FormatConditional Formatting
Select Formula IS
Enter this formula:

=AND(ISNUMBER(A5),A5DATE(YEAR(TODAY()),MONTH(TODA Y())-3,DAY(TODAY())))

Click the Format button and select the style(s) you want
OK out

Biff

"Debbie F" <Debbie wrote in message
...
Hi

I have a date in A5 and I need to write a formula in an adjacent column
that
checks the date and if the date is less than 3 months old to display it in
another colour, if it is more than 3 months old to do nothing.

I am not sure which date function to use. Can anyone help?

Thanks