Thread: [Solved] Formula to append date to a value
View Single Post
 
Old 11-01-2018, 07:44 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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.
Reply With Quote