View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
derk derk is offline
external usenet poster
 
Posts: 1
Default 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?