Biking Loki
Board Regular
- Joined
- Aug 25, 2005
- Messages
- 167
I wasn't able to find a solution based on searching the forum...
I'm looking for a way to compare a day as a word and as a date.
For example, I have the word 'Sunday' in A1 and the date January 16, 2022, formatted as Sunday (dddd format), in A2. Is there a way to make a formula in A3 that will compare the two and say that they match because they both say Sunday even though one is a word and the other is a date?
I'm looking for a way to compare a day as a word and as a date.
For example, I have the word 'Sunday' in A1 and the date January 16, 2022, formatted as Sunday (dddd format), in A2. Is there a way to make a formula in A3 that will compare the two and say that they match because they both say Sunday even though one is a word and the other is a date?