=NETDAYS FORMULA

Nicolepg

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!

David Joyeuse

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.

Nicolepg

Hi @David Joyeuse

Thanks for your response, unfortunately that is not the issue, both columns are set to date columns.

David Joyeuse

@Nicolepg

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.