Date Format

Phil H · #1 03-28-2018, 05:22 AM

Cell A1 holds a date, 6/15/2018. Cell formatted as a date.
Cell AK2 holds this formula: ="Expirations before "&A1
Formula returns: Expirations before 43266

Need formula to return: Expirations before 6/15/2018

How is this done?

deciog · #2 03-28-2018, 05:32 AM

="Expirations before "&TEXT(A1,"dd/mm/yyyy")

Decio

Phil H · #3 03-28-2018, 06:45 AM

Thanks, deciog! Works perfectly.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't format date to MM/DD/YY	gogreen	Excel	2	10-31-2016 03:24 PM
Date format	Welda Tait	Outlook	2	05-13-2016 01:26 AM
Date format but with Jan Feb mar etc how is this done ?	DBenz	Excel	3	12-21-2014 05:00 AM
Letter date changes when merging with Excel - not the format, the actual date!	Smallweed	Mail Merge	1	02-07-2014 06:00 PM
date format	gsrikanth	Excel	1	12-28-2011 05:06 AM