How to return date format in cell instead of general format?

Hello all,

On my first tab, I am referencing a date in cell k2 from the 2nd tab (called actions.).

Can someone tell me how to amend the formula to show the UK date format: 19/05/2021 instead of 44337 as it is showing at present?

Thank you

Select Date format?

hI tms, I have to no avail sadly

I think we may need to understand in more detail what you need. Making the "date format" a part of the formula involves converting a number/date into a text/date using the TEXT() function https://support.microsoft.com/en-us/...8-93d29371225c However, converting a number to text usually creates more problems than it solves. I think there is value in explaining exactly why you need the formula to do the date formatting (which stores the number as text) and not use an appropriate number format (which keeps the number stored as a number and changes the display to the desired format).

TY MrShorty, article helps!