NETDAYS returning #INVALID DATA TYPE
Hi -
I'm trying to calculate the number of days between two dates in a sheet. I have both of my columns that contain the start and end dates set up as DATE column type.
They both contain dates.
I use the formula "=NETDAYS([Hotel Check-In Date]@row, [Hotel Check-Out Date]@row)".
I have tried making the results column a DURATION type column as well as Text/Number and still get the error.
What am I doing wrong?
Answers
-
Hi,
Is the fields you reference in the formula both date format?
Best,
Beata
-
Yes, they are both in mm/dd/yyyy format.
-
@Meredith Fenwick , That's really odd. The only thing I can think to do is what @SmartWay360 suggested and double check again the column type by Edit Column Properties for both of those columns. I realize this suggestion is likely frustrating... and I almost didn't post. I really don't know what else to try. Something is making the input values into the netdays() function into something other than dates. Maybe check to make sure the column names are spelled correctly in the formula. Maybe you have a similarly named column with a different data type.
Good luck as you keep troubleshooting. Be well.
If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!