NETDAYS #INVALID DATE TYPE

I can't figured out why #INVALID DATA TYPE auto fill when I haven't pick a date for the start and finish date. If I do have those fill out then the formula works fine but otherwise it just fill the duration cell with that error. I do have the duration column under Text/Number. The only thing that I can think about is that I have multiple reports that generate from this Master Sheet but other than that I don't see where is the mistake.

Find more posts tagged with

Construction

Formulas

Project Management

Account and User Management

Comments

Dan Seidler

Try wrapping your formula with an IFERROR formula. Use "" to return a blank.

=IFERROR(NETDAYS([Concept Start Date]@row,[Concept Finish Date]@row),"")

@HELP@

Thanks!!!

It worked! I ended up using the formula

=IFERROR(NETDAYS([Concept Start Date]10, [Concept Finish Date]10), "")

it actually delete the #INVALID DATA TYPE

Dan Seidler

Using @row instead of the row number just makes it easier to copy formulas. You may run into a situation where you copy the formula, to say row 700, and the formula still shows row 10 (using the data on row 10, instead of row 700).

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…