I'm trying to construct an Excel formula to compare the date in column A to the date in column B, tells me YES if they are the same date, tells me NO if they are different dates, then if NO tells me what is the oldest of the two dates.
What I have is not working...
=IF(A1=B1,"YES","NO"&(A1,B1))
No comments:
Post a Comment