#1
|
||||
|
||||
Formula to append date to a value
Hello. I want this formula to return <DRP:June 6, 2018> but what came out was <DRP:43257>. What do I need to add to the formula to return the correct date format?
=IF(NAME="","",INDEX(REMARKS,MATCH($C15,FULLNAME,0 ))&":"&INDEX(DATE_OF_REMARKS,MATCH($C15,FULLNAME,0 ))) Thank you. |
#2
|
||||
|
||||
Try TEXT(INDEX(DATE_OF_REMARKS,MATCH($C15,FULLNAME,0)),"mm d, yyyy") after the &
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
||||
|
||||
Yay, the TEXT and the date format did it! Thank you.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date Formula Issue | matteu1 | Mail Merge | 1 | 07-23-2018 04:53 AM |
Formula for looking at 1 cell with a date and then comparing it to four date ranges | LearningMom | Excel | 3 | 10-27-2017 12:44 PM |
append multiple time values to date in one column | sarahafeez | Excel | 1 | 09-25-2017 11:01 PM |
Formula to return a date | caz46 | Excel | 3 | 04-15-2015 08:59 AM |
Need a date formula | MPAVLAS | Excel | 3 | 08-12-2010 10:04 PM |