Excel Help

[Eli]

Hi guys. First time poster in this forum. 😉 lol

Ok, here's the problem. I'm trying to call dates from multiple cells on Sheet2, and put them into a single cell on Sheet1.

It works, but Excel displays the two serial numbers, rather than the two dates. How do I fix this? Here's my code:

=IF(AND(RTV!AE29=0, RTV!AE30=0),"Not Filled Out",RTV!AE29 & CHAR(10) & RTV!AE30)

I don't think there's anything wrong with the code. Does it have to do with cell formatting? Is there a format for multiple dates? lol

Thanks!

 

[GaryJohnson]

Try:

=IF(AND(RTV!AE29=0, RTV!AE30=0),"Not Filled Out",TEXT(RTV!AE29,"mm/dd/yyyy") & CHAR(10) & TEXT(RTV!AE30,"mm/dd/yyyy"))

 

[Eli]

Sweet! Thanks. 🙂 That worked.

/notes TEXT function....