IF statement to compare columns of dates

mmj1
mmj1 used Ask the Experts™
on
I have Excel 2016 and two rows of dates - I am trying to compare two columns of dates to determine if they are the same or different - I thought I might be able to use an IF statement but would appreciate your help - i.e, dates in column A & B - can insert a column C - if the dates match in A & B enter "Yes" if they are different enter "No" - thanks,
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Consultant
Commented:
If(A1=B1, "Yes","No")

Author

Commented:
That worked great!!  Thank you!
Tom FarrarConsultant

Commented:
Glad to help!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial