Can anyone see why two results in the attached sheet are wrong?

asked 2018-07-02 16:41:21 +0100

ThreeScore
21 ●1 ●4

I have a spreadsheet that calculates the number of days since the start date for a number of dates entered in a column. It seems to work for most dates but in two rows I get a a negative number. C:\fakepath\Wrong result.ods

edit retag flag offensive close merge delete

add a comment

2 Answers

Sort by » oldest newest most voted

answered 2018-07-04 12:34:41 +0100

ThreeScore
21 ●1 ●4

Thank you. I made the mistake of thinking the edit field showed me the value. Double clicking on the cell showed me the true value in the field. I have changed it and it is all fine now.

edit flag offensive delete link

Comments

Please add a comment, don't user an answer for that. And if the answer solves your question please tic the V

m.a.riosv ( 2018-07-04 22:49:06 +0100 )edit

add a comment

answered 2018-07-02 16:47:16 +0100

erAck

3388 ●26 ●44 https://erack.de/

The results are not wrong, but your data is. Cell A31 contains 0018-03-31 instead of 2018-03-31 and cell A39 contains 0018-06-29 instead of 2018-06-29.

edit flag offensive delete link

add a comment

Question Tools

1 follower

Stats

Asked: 2018-07-02 16:41:21 +0100

Seen: 37 times

Last updated: Jul 04 '18

Can anyone see why two results in the attached sheet are wrong? edit

2 Answers

Comments

Question Tools

Stats

Related questions

Can anyone see why two results in the attached sheet are wrong?