How about a conditional (Fill color) format.

"Michell Major" wrote:

Roger. As ever thanks.

I have two options. First to use a hidden column for the formula. Second,
if the date is 'overwrites' the formula I think it'll be OK because it
assumes that ation has been taken. I'll tryyour formulae.

Regards

"Roger Govier" wrote:

Hi Michell

You cannot have a formula in a cell as well as an entered value.
You could have a formula there to display one the 2 other dates, and
that formula would then be over-ridden and destroyed when you type in an
action date.
Do you want the earlier or the later of Destroyed or Claimed?

If earlier, then
=IF(COUNT(C2:D2)<2,MAX(C2:D2),MIN(C2:D2))
If later, then
=MAX(C2:D2)

--
Regards

Roger Govier


"Michell Major" wrote in
message ...
There are 4 columns with dates; 1. Date In 2. Date Actioned 3. Date
destroyed
4. Date claimed.

If date Actioned is left blank I want date Destroyed or date Claimed
data to
be automatically displayed in the Actioned column.