Weston has attended:
Excel Advanced course
Dates
I am trying to subtract between two dates but the result I am getting is #value. Please how do i resolve this.
RE: 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