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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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