NETDAYS is giving wrong result

rakis19

The NETDAYS between 5-Aug-2018 and 9-Aug-2018 is coming as 36530. I don't know what's happening - can anybody help?

=NETDAYS([Last Date Entered]4, Today4)

 

The same formula in another sheet is working absolutely fine.

Javed Hassan

Re-type your dates in. Looks like you accidentally put in 2118 instead of 2018 for the year, but since it's formatted as YY instead of YYYY, it looks right.

J. Craig Williams

Good catch Javed!

Craig