Compare dates in the same row but different columns

Scott Rae

Hi all,

Im looking at counting the number of times two date columns differ within the same row

For example

Column 1 Column 2

11/2/20 11/2/20

11/4/20 14/11/20

11/3/20 11/3/20

25/5/20 12/6/20

In this data the answer i am looking for is 2 as row 2 and 4 both differ, whereas in row 1 and 3 the dates are the same in both columns

If anyone has had a similar issue and came up with a formula to do this that would be a great help

Many thanks

Find more posts tagged with

Formulas

Accepted answers

Chris Mondeau

Hi @Scott Rae ,

I used a helper column to check if the two dates are different, and if so, returned a value of 1. Then I used a sheet summary field to sum the "Different" helper column to get the total. Hope that helps a little!

All comments

Chris Mondeau

Hi @Scott Rae ,

Scott Rae

@Chris Mondeau Fantastic,

That completely solved my problem.

Thanks so much :)

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.