Find Unique Dates from 2 Date Columns

Frank S.

Problem of the Day:

I have 2 date columns with different dates. I want to create a 3rd column that lists only the unique dates from both columns.

Suggestions?

Paul Newcome

Are you able to provide some screenshots with manually entered data for reference?

Frank S.

I have attached a screenshot

Screen Shot 2021-09-23 at 7.10.34 AM.png

Paul Newcome

Ok. And exactly which dates would end up in the Unique Dates column?

Frank S.

@Paul Newcome

All of the uniques dates from both columns would go into the unique dates column.

In other words, only the dates that appear once in either column will end up in the unique dates column.