Thread: [Solved] Date Format
View Single Post
 
Old 03-28-2018, 05:22 AM
Phil H Phil H is offline Windows XP Office 2010 64bit
Advanced Beginner
  
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default Date Format
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?
Reply With Quote