Formula to append date to a value

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to append date to a value

FAQ

Thread Tools

Display Modes

11-01-2018, 07:44 PM

Marcia

Windows 7 32bit Formula to append date to a value

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 554

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:47 AM.