Desperate in need of help on dates matching

[kiatemail]

I am trying to match 2 dates. Previously was fine but now the formula does not work. If(date1-date2,"","please check"). Anyone can advise what's wrong?

[kiatemail]

Formula is per screenshot not the text comments

[kiatemail]

A check on the column c value shows up digits like 41647 etc

[Tony Valko]

In Excel dates are really just numbers formatted to look like dates. These numbers are commonly referred to as the date serial number. The date serial number is the count of days starting from a base date. In Windows Excel the default base date is January 1, 1900. So, January 1, 1900 is date serial number 1.

Jan 1 1900 = date serial number 1
Jan 2 1900 = date serial number 2
Jan 3 1900 = date serial number 3
Jan 4 1900 = date serial number 4
Jan 5 1900 = date serial number 5
etc
etc
Jan 1 1975 = date serial number 27395
Jan 1 2000 = date serial number 36526
Jan 1 2016 = date serial number 42370

You can see the date serial number by entering some date in a cell and then changing that cells format to General or Number.

So, 41647 is the date serial number for the date Jan 8 2014.

[kiatemail]

It doesn't allow me change the format of the cells. What could be the issue?

[Tony Valko]

How big is the file?

If it's not too big and you're able to, post the file so we can see what the problem is.

Make sure you tell/show us exactly where the problem is. In fact, it would be helpful if you deleted all of the irrelevant data. It just makes finding what we're looking for harder.

[Sun13Banjo]

The problem is the dates in column C have been entered in the wrong format so they are not actually numbers/dates. If you can change them to a dd/mm/yyyy format the formula will work

Sun

[kiatemail]

The problem is the dates in column C have been entered in the wrong format so they are not actually numbers/dates. If you can change them to a dd/mm/yyyy format the formula will work

Sun

Hi, I found the solution. It's because my system somehow set it to US date and I need to change to uk date in control panel. Thanks guys!

[Tony Valko]

Good deal. Thanks for the feedback!