Dates

Hi,

A #value error means that you are doing something that doesn't make sense to Excel for the data type. It's like trying to add up a text string. You can add up numbers but not text.

My first thought would be that excel doesn't recognise on of the dates you are using in your calculation as a date.

Are you holding the dates in separate cells? This is the most reliable was to do this type of calculation.
If so then your formula would be something like this:
=A1 - B1
where A1 has the more recent or future date and B2 the older date.

Do you have all the information in the formula like this:
= 10/5/2019 - 1/5/2019

this is less reliable as this formula gives an answer so: 0.00089153

This is probably due to Excel interpreting the slashes as division operators.

Can you include your formula? Are your dates displaying correctly?

thanks
Claire