=DAYS(end date, start date) error

I use a template that includes a column of =DAYS(end date, start date). One particular cell refuses to display correctly.
That column had been filled with =NETWORKDAYS(start date, end date) cells.
I replaced =NETWORKDAYS(start date, end date) function with =DAYS(end date, start date) function.
The cell in question contains a very large negative number, reflecting that =NETWORKDAYS (start date, end date) is still partially active. That cell shows -657358 when the actual number is 78.
All other cells in that column display correct numbers.
All cells in that column are formatted (Number #).
How might I display that cell correctly ?
Thanks !
Rob

Thank you PKG ! I had rotated a date.

Please upload an ODF type sample file here.

All cells in that column are formatted (Number #).

This does not assure, that content is really a number. If you had text in cell, formatting won’t turn it to a number. The only method to see the data type is to enable View -> Value Highlighting

  • blue → data type is Number
  • black → data type is Text
  • green → data type is “Formula

07/01/21 IBKR 09/17/21 -657359
-657359 now displays in green font

Sure - you need to check the data type of the cells used in the formula (e.g. D28868 and A28868). Function DAYS() requires numbers (which is the type of dates) and we need to know the numbers used in that formula.

Check 09/17/21 for rotated numbers!

06/30/2021 - 09/17/0221 = -657358

06/30/2021 - 09/17/0221

Or rater the other way round.

Nice catch! :+1:t3:

Unfortunately, the OP will only learn that they may still be absolutely careless about what data they provide in the question, and anyway there will be someone who figures it out from the provided garbage.

And unfortunately, we still have 2-digit years as default for almost all locates. :worried:

1 Like
  1. 06/30/21 IBKR $65.71 09/17/21 -657358
    Cell displaying -657358 contains =DAYS(D28868,A28868)
    The source template of that cell contains =DAYS(D39,A39)
  2. I need >5 points to upvote ?
    I hope you can find this reply. Thanks ! Rob

What should we read from this? Please upload a sample file.


Please do **not** use *Add Answer* but **edit** your original question to enhance the details of your question and/or to upload sample file(s) (answers are reserved for solutions to a problem on this Q&A site). Thanks in advance …