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

If you have your fixed date in a cell, e.g. Z1 use this formula in A1

=IF(D1="x",Z1,"")

otherwise you can reference the date directly in the formula, e.g.

=IF(D1="x",DATE(2005,12,31),"")

format cell as a date

in C1 formula should be

=IF(A1<"",B1-A1,"")

format as general


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=508778

Thank you it works like a charm.

Gilles
"daddylonglegs"
wrote in message
news:daddylonglegs.22rwny_1139171400.8195@excelfor um-nospam.com...

If you have your fixed date in a cell, e.g. Z1 use this formula in A1

=IF(D1="x",Z1,"")

otherwise you can reference the date directly in the formula, e.g.

=IF(D1="x",DATE(2005,12,31),"")

format cell as a date

in C1 formula should be

=IF(A1<"",B1-A1,"")

format as general


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=508778