Dates & Formulas

Garmon D

Hi,

I'm trying to create a formula to work out the difference in days between 2 cells, both of which have values derived from different column formulas. The output column is giving me #Invalid Data Type. Any thoughts as to how I fix the issue?

Column37:

=NETDAYS([Column31]@row, [Column34]@row)

Matt Johnson

Hi @Garmon D

I think one of your date columns isnt a date formatted column. Changing that should fix it.

Thanks,

Matt