Date Function

[Gusher]

Hi,

In cell A1 I have 2019 in cell A2 I have Aug in cell A3 I have 19. I need a function that will return the date 19/8/2019

Many Thanks

Mark

 

[Joe4]

Use this formula:

=DATEVALUE(A3 & " " & A2 & " " & A1)

and format the results as: d/m/yyyy
to return a valid date value.

To return a text value, you can simply use:

=TEXT(DATEVALUE(A3 & " " & A2 & " " & A1),"d/m/yyyy")

 

[DanteAmor]

Try

=(A3&A2&A1)+0