Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If cell is blank automatically enter today's date in the same cell | Excel Discussion (Misc queries) | |||
Excel 2003 make 1 date cell automatically change another date cell | Excel Worksheet Functions | |||
Automatically change cell colors based on date in cell | Excel Discussion (Misc queries) | |||
Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |