Respuesta :

Excel will display an error value, if you used a formula to perform arithmetic operations on dates but one of the dates was typed in a format that excel does not recognize as a date.

Moreover, The cell is formatted as Text, which causes Excel to ignore all formulas. This can be directly caused by the Text format, or is especially common when importing data from a CSV or Notepad file. Fix Change cell format to General or other format.

You can learn more about this at:

https://brainly.com/question/15399842#SPJ4

Excel will appear an error value if you used a formula to perform arithmetic operations on dates, but one of the dates was typed in a format that excel does not recognize as a date.

Error value that often occur in excel when you input formula, can be meant by something is wrong with the formula or the cells that it references. Error value is vague, and it can be hard to find the reason why it happen. The #VALUE! error display if a value is not correct of type. This can happen if cells are left blank, when a formula or function that is expected a number is given a text value, and when dates are evaluated as text by Excel. Error value is caused by a reference becomes invalid.

Learn more about Error value at https://brainly.com/question/6490181

#SPJ4