ExcelBanter - Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel (https://www.excelbanter.com/excel-discussion-misc-queries/118257-excel.html)

Mary Margaret

Excel

I have fixed an excel document with a formula to figure dates, but if I don't
put a figure in the cell that it refers to, there is a date where the formula
is and I don't want a date there unless I put a date in the cell the formula
references. How do I do that?

MyVeryOwnSelf

Excel

I have fixed an excel document with a formula to figure dates, but if
I don't put a figure in the cell that it refers to, there is a date
where the formula is and I don't want a date there unless I put a date
in the cell the formula references. How do I do that?

On way is to use a formula something like:
=IF(A1="","",your_formula_here)

All times are GMT +1. The time now is 04:53 AM.