=NETDAYS FORMULA
Hi,
I am trying to calculate how many days it has been since a unit was paid for however I am getting the #INVALID DATA TYPE error. I am assuming the issue is that one of the dates I am referencing is pulling the date from a different sheet using a VLOOKUP formula. Is that the issue and is there a work around for it?
Any help is appreciated!
Answers
-
Hi @Nicolepg
#INVALID DATA TYPE probably means that either (or both) your [Finance Date] column and [Today] column aren't date columns.
Looking at the screenshot, I would say the [FINANCE DATE] column is a text/number cell. Turn it into a date column should solve the problem.
-
Thanks for your response, unfortunately that is not the issue, both columns are set to date columns.
-
What is the type of the column where you're getting the FINANCIAL DATE value?
If you look it isn't displayed the same way as it is in the today column. So that probably comes from here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K 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
- 287 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!