I used if function to compare two dates from two different resources but it didn't work out.

Here my sample:A1 B1

12/31/2013 12/31/2013IF(A1=B1,"yes",FALSE)

It is something with the dates but I don't know how to fix it. Please help. Thanks,

Sorry, that looks all greek to me...why not explain EXACTLY what you are trying to do? What is if function? HELP in posting on Computing.net plus free progs and instructions

I have two different reports from different source and need to compare the two dates if it is the same or not but my formula =IF(A1=B1, yes, ) does not come out right answer.

from two different resourcesMost likely either one or both your Dates are not DATES as Excel sees them,

but Text Strings that look like Dates.A quick way to determine if they are real DATES,

select both date cells and format them as Numbers.If they still display as Dates, IE 12/31/2013 then they are TEXT Strings.

If they display as a four digit number like: 42004 then they are real DATES.

MIKE

Ask Your Question

Weekly Poll