Create list of text dates in one cell from separate cells containing a date serial.

**MinMn** · 04-02-2012, 10:16 AM

Hello,

I'm trying to create a list of text dates in one cell from separate cells, each containing a date serial.

The formula I've used is:

=TEXT(R19,"mm, dd, yyyy")&""&TEXT(S19,"mm, dd, yyyy")&""&TEXT(T19,"mm, dd, yyyy")&""&TEXT(U19,"mm, dd, yyyy")

(where R19, S19, T19, and U19 each hold a date serial).

But I'm receiving the NAME error. Any ideas?

Thanks.

**galvinpaddy** · 04-02-2012, 10:30 AM

Can you load a sample sheet please?
galvinpaddy

**darknation144** · 04-02-2012, 11:03 AM

You should be using one of the date functions not text I think.

**MinMn** · 04-02-2012, 11:18 AM

Here is a sample sheet. I want cell C5 to read:

2/27/1980 3/23/1998...

Thanks!

**darknation144** · 04-02-2012, 11:33 AM

Sample Date List Q.xlsx

There you go

**MinMn** · 04-02-2012, 11:51 AM

Wow- that easy. Just missing brackets. Thanks a bunch.

Create list of text dates in one cell from separate cells containing a date serial.

LinkBack

Thread Tools

Rate This Thread

Display

Create list of text dates in one cell from separate cells containing a date serial.

Re: Create list of text dates in one cell from separate cells containing a date serial.

Re: Create list of text dates in one cell from separate cells containing a date serial.

Re: Create list of text dates in one cell from separate cells containing a date serial.

Re: Create list of text dates in one cell from separate cells containing a date serial.

Re: Create list of text dates in one cell from separate cells containing a date serial.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions