Thread: Formula involving a date

Hi there,

I have the following formula

="vs "&AF1&" "&( AF3)

Where AF1 is a name and AF3 is a date. At the moment it is returning the date as a 5-digit number (e.g.40054) rather than in the format dd/mm/yyyy which is what AF3 is formatted to.

Any suggestions?

You need to use the TEXT function and specifiy the date format you require, i.e. something like this:

="vs "&AF1&" "&TEXT(AF3,"dd/mm/yyyy")

Problem solved.

Thanks very much.