Unable to use if function for comparing two days

June 15, 2014 at 18:49:17
Specs: Windows 7
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/2013


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

See More: Unable to use if function for comparing two days

Report •

June 15, 2014 at 21:21:11
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

Report •

June 15, 2014 at 22:42:29
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.

Report •

June 17, 2014 at 05:18:14
from two different resources

Most 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.



Report •
Related Solutions

Ask Question