NETDAYS, NETWORKDAYS Function Returning Error

rmiro

Hello,

I'm trying to calculate the days in between the two dates in the columns below but any formula I use keeps returning an error. Does anyone have any suggestions on how I can fix this?

I've tried simple [Initial Request Date] - [Date of Response] formula and even tried the NETDAYS/NETWORKDAYS nested within IFERROR function and it's still not returning the correct numbers.

Things to know:

"Date of Response" column is a formula converting the Created Date column into date only (using =DATEONLY function)

"Initial Request Date" column contains a formula that takes the Created Date from another sheet based on certain criteria and formatted into date only in that column.

Cory Page

Usually its a format issue but I double checked and it seems to work on my end when I use your descriptions. Can you paste the formula you're using real quick just in case its a typo? Also can you double check that your column properties are set to Date, I am sure they are but it helps rule something out. Thanks,

rmiro

@Cory Page

I tried this formula

I also tried this formula

=NETWORKDAYS([Initial Request Date]@row, [Date of Response]@row)