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.