Error Using Max Function

Laura Krylov ASGLLC

Having an issue with the Max formula. Appreciate any advice the community can provide.

This formula is giving me an Invalid Column Error:

=MAX([End Date]195:[End Date]220)

However, this one works fine so I don't see why there would be an invalid column error on the first formula.

=NETWORKDAYS([End Date]207, [Start Date]@row)

Carson Penticuff

Is the column you are inserting the formula into formatted as a date column?

Carson Penticuff

Is the column you are inserting the formula into formatted as a date column?

Laura Krylov ASGLLC

@Carson Penticuff Yes, it's a date column.

Laura Krylov ASGLLC

@Carson Penticuff I realized what I did. I was testing out components of a nested formula but I did it in the wrong column. I was using a Text column to test the formula but of course the formula result was a date. This full formula works.

=NETWORKDAYS(MAX([End Date]195, [End Date]220), [Start Date]@row)

Thank you for your willingness to help!

Carson Penticuff

I'm glad you got it worked out!