Ask Your Question

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

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

ThreeScore gravatar image

updated 2020-07-28 21:14:19 +0200

Alex Kemp gravatar image

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-28 21:14:27.031966

2 Answers

Sort by » oldest newest most voted

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

erAck gravatar image

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 more

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

ThreeScore gravatar image

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 more


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 gravatar imagem.a.riosv ( 2018-07-04 22:49:06 +0200 )edit

Question Tools

1 follower


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

Seen: 166 times

Last updated: Jul 04 '18