Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-01-2018, 07:44 PM
Marcia's Avatar
Marcia Marcia is offline Formula to append date to a value Windows 7 32bit Formula to append date to a value Office 2007
Expert
Formula to append date to a value
 
Join Date: May 2018
Location: Philippines
Posts: 526
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
  #2  
Old 11-02-2018, 01:24 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Formula to append date to a value Windows 7 64bit Formula to append date to a value Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 11-02-2018, 02:32 AM
Marcia's Avatar
Marcia Marcia is offline Formula to append date to a value Windows 7 32bit Formula to append date to a value Office 2007
Expert
Formula to append date to a value
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Yay, the TEXT and the date format did it! Thank you.
Reply With Quote
Reply

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 append date to a value Formula to return a date caz46 Excel 3 04-15-2015 08:59 AM
Formula to append date to a value Need a date formula MPAVLAS Excel 3 08-12-2010 10:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft