keep cell as a date cell
Hi,
My problem is the following (Office Excel 2003):
- cell A55 is formatted as a deta-cell and has a formula which says to add
14 days to the date in cell F24;
- however, if another cell (D38) is empty/blank, than cell A55 should remain
empty/blank. Only if there is information in cell D38, should the date in A55
show up.
As soon as I fill in =IF(D380;"(=F24+14)";"") in A55, cell A55 does indeed
stay empty as long as nothing is filled in in D38. But with information in
D38 cell A55 shows (=F24+14).
What is wrong with the formula in A55? Can you help me?
|