Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
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.
Comments
-
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.
-
Good catch Javed!
Craig
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!