Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

dates

ResolvedVersion 2016

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

RE: dates

Thanks Claire

Excel tip:

Add a € to your cells

If you need to add a € symbol to your Excel sheet - hold down the key Alt Gr and 4.

Alt Gr is located on the right side of the space bar.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.