Comparing a day of the week to a date

B

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?
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
How about
Excel Formula: 
=a1=text(a2,"dddd")
 
Upvote 0
Solution
You're welcome & thanks for the feedback.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Solved
Data Validation from a list OR Sunday date?
2
Replies
12
Views
583
Peter_SSs
Peter_SSs
S
  • Solved
Change sheet tab color based on day of the week
Replies
6
Views
667
SubwaySparky
S
J
  • Question
How to allocate project hours between specific dates using specific daily hour burn rates and including awkward calendar month start/end+holidays
2
Replies
11
Views
1K
felixstraube
F
J
  • Solved
Add 1 day to a date within a range as long as 2 conditions are met [without macros]
Replies
4
Views
566
juanam
J
T
  • Question
Tracking sheet date > Due date > days left
Replies
2
Views
262
Drrellik
Drrellik

Forum statistics

Threads
1,215,062
Messages
6,122,923
Members
449,094
Latest member
teemeren

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top