combine TEXT function with INDEX function

**kmbondra** · 06-12-2015, 12:29 PM

Hi,
I wish to link data from one sheet to one cell on another sheet, and also have the data read across from data that was entered down.

all is working fine, except that i would like the data that is a date to read as a date, not numbers. I cant figure out where to enter TEXT in my formula string.

&" "&(INDEX(entry!$H$3:$H$1000,COLUMNS($H$3:H3)))

this is a portion of the formula. but this is linking the date data column. so column H is all dates. I'd like it to read as a date on the second sheet.

thanks!

**samba_ravi** · 06-12-2015, 12:44 PM

please attach sample excel file for better understanding of your requirements

**Pepe Le Mokko** · 06-12-2015, 12:47 PM

Perhaps TEXT(INDEX(entry!$H$3:$H$1000,COLUMNS($H$3:H3))),"mm/dd/yyyy") to return as date format ?

**kmbondra** · 06-12-2015, 01:44 PM

HI Pepe, thanks for the suggestion, i couldn't get it to work tho

See origninal post, i have attached the file.
on the second tab, cell c3 contains the formula, and i plan to drag it across the other 2 cells on that row, to correspond with the data on tab 1.

**kmbondra** · 06-13-2015, 10:36 AM

Originally Posted by Pepe Le Mokko

Perhaps TEXT(INDEX(entry!$H$3:$H$1000,COLUMNS($H$3:H3))),"mm/dd/yyyy") to return as date format ?

Hi Pepe
After careful studying of your formula, I removed one parenthesis and it worked perfect! :D
Thanks
TEXT(INDEX(entry!$H$3:$H$1000,COLUMNS($H$3:H3)),"mm/dd/yyyy")

**Pepe Le Mokko** · 06-13-2015, 12:39 PM

Ooops sorry for the typo

combine TEXT function with INDEX function

LinkBack

Thread Tools

Rate This Thread

Display

combine TEXT function with INDEX function

Re: combine TEXT function with INDEX function

Re: combine TEXT function with INDEX function

Re: combine TEXT function with INDEX function

Re: combine TEXT function with INDEX function

Thread Information

Users Browsing this Thread

Similar Threads

Combine max function today() and index....

Combine INDEX with INDIRECT + MATCH FUNCTION

Creating a VBA function to combine INDEX and MATCH

Combine Text & A Logic Function

[SOLVED] How can I combine text and a function in a single cell

Bookmarks

Bookmarks

Posting Permissions