I have a row containing dates:

```
05/10/15    06/10/15    07/10/15    08/10/15    09/10/15    10/10/15    11/10/15
D3:J3

```

I have a cell (`D5`) with the following value:

```
=NOW()
//Returns "07/10/15"
//The cell is formatted to exclude time.

```

I have this function (E5):

```
=ADDRESS(3,MATCH(D5,D3:J3,0),1,4)

```

The aim is to match the current date with a date from a given selection and return the cell address. The function does not work and I am not sure what I am missing.

I added the following function to check the values:

```
=IF(F3=D5,TRUE,FALSE)

```

This returns `FALSE`, which could be one of the reasons the main function is falling over.

```
NOW() != "07/10/15"

```

How can I fix this?

`TODAY() == "07/10/15"` which solved that half of the issue

The Function is now finding a match but return the value `C3` the value with the matched date is `F3` which is the value I want returning.