|
|
#1
03-28-2018, 05:22 AM
|
|||
|
|||
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? 
|
| Tags |
| date, date format |
|
|
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 |
Windows XP 
Office 2010 64bit
Threaded Mode