Ask Your Question
1

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

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

ThreeScore 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 close merge delete

2 Answers

Sort by » oldest newest most voted
3

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
1

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

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

Question Tools

1 follower

Stats

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

Seen: 39 times

Last updated: Jul 04 '18