momma2all wrote:
I am trying create the following statement - however I want the value of the
cell to appear not the cell position:

IF(S5U6,"S5", IF(S5<U6, "U6"))

the values in in the cells are dates; hoever, when I enter the statement the
cell populates as S5 or U6 not the date that is formatted in the appropriate
cell.

Hi there,

Try removing the quotes:
IF(S5U6,S5,IF(S5<U6,U6))

Or even
IF(S5U6,S5,U6)

Or perhaps
MAX(S5,U6)