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)

Find more posts tagged with

Accepted answers

Carson Penticuff

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.