Hi everyone,

in A1 I would like to generate a fixed date based on what is happening in
B1, C1 and D1

B1= today() C1= B1-A1 D1 is most of the time "empty"

When D1 is empty, A1 should be empty but when an X is inserted in D1 a fixed
date should be generated in A1, therefore the result of A1 is used in C1.

Hope this is clear.

TIA

Gilles