The use of Netdays function

Afolakemi Jedidiah

I am hoping someone can help.

I have used Netdays function to check the difference between lastupdated and today. However I have some empty cells which has come back as invalid data type, how do I bypass this function or is there another function to make this work?

Jeff Reisman

@Afolakemi Jedidiah

Have you tried using IFERROR to suppress the #INVALID DATATYPE message on rows with empty values?

The syntax is:

=IFERROR(your NETDAYS function goes here), "")

The , "") at the end tells the system "if this formula returns an error, replace the result with "", which means a blank cell."

Jeff Reisman

@Afolakemi Jedidiah

Have you tried using IFERROR to suppress the #INVALID DATATYPE message on rows with empty values?

The syntax is:

=IFERROR(your NETDAYS function goes here), "")

The , "") at the end tells the system "if this formula returns an error, replace the result with "", which means a blank cell."

Afolakemi Jedidiah

@Jeff Reisman Thank you . it worked