Find Unique Dates from 2 Date Columns

Frank S. · 09/22/21

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 · 09/23/21

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

Frank S. · 09/23/21

I have attached a screenshot

Paul Newcome · 09/23/21

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

Frank S. · 09/23/21

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.

Answers