NETDAYS #INVALID DATE TYPE

Rosario Barros

I am trying to get days between 2 dates with the following formula.

=NETDAYS([End date]3, [CR1 - Fabric yardage]3)

One of the dates came from another sheet, with formula. If I type a date on top, the formula works fine.

How could I fix it?

Thanks!!

Paul Newcome

There is the issue. The + "" on the end is converting it to a text string instead of a date value. Is there a reason for this?

Paul Newcome

The data coming over from the other sheet isn't coming over as a date value.

What is the formula populating the date in the other sheet? Is the column type in the other sheet a date type column? Exactly how are you pulling the data into the current sheet? If it is a formula, what is it?

Rosario Barros

Hi Paul, The column type is date in both sheets. I am pulling the data with Vlookup

Thanks!!

Paul Newcome

What is the formula populating the date in the source sheet?

Rosario Barros

This is the formula

=VLOOKUP(Calendar@row, {Calendar - Milestone Range 2}, 2, 0) + ""

Paul Newcome

There is the issue. The + "" on the end is converting it to a text string instead of a date value. Is there a reason for this?

Rosario Barros

that was the issue.. first the vlook up was not working correctly, so I added that! thanks a lot!!

Paul Newcome

Happy to help. 👍️