try
formula is
=today()DATE(YEAR(B6),MONTH(B6)+6,DAY(B6)-1)

--
Don Guillett
SalesAid Software

"Andrew" wrote in message
...
How do I counter my date???

"Don Guillett" wrote:

have a look at formatconditional formatput in an appropriate formula

--
Don Guillett
SalesAid Software

"Andrew" wrote in message
...
I am dealing with a date of lets say 5/5/05 in Cell B6, and six
months
later
I want to be informed in Cell B7 of the Due Date (11/5/05) and Color
change
of that cell (B7) to red. How do I do this???