dates in sentences 3

[dbpcar]

I have a concatentate sentence that includes a date. The date comes up in number format, not date format
="not funded as of "&N2 n2 has the date in it.
It comes up 37666 or some such, the absolute reference. Is there a way to convert this to a date that is recognizable?
dbpcar

 

[luceze]

Something like this should work.


="not funded as of "&MONTH(N2)&"/"&DAY(N2)&"/"&YEAR(N2)

HTH,
Eric

 

[mbarron]

="not funded as of "&text(n2,"mm/dd/yyyy&quot

I banged my head with this same issue yeaterday for about half an hour.


Mike

 

[bluedragon2]

="not funded as of " & MONTH(N2) & "/" & DAY(N2) & "/" & YEAR(N2)



Blue

If I wasn't Blue, I would just be a Dragon...

 

[SkipVought]

Hi,

If you embed dates in strings alot, you might want a user-defined function like this ...

Function Date_String(dDate As Date) As String
    Date_String = Month(dDate) & "/" & Day(dDate) & "/" & Year(dDate)
End Function

="not funded as of "&Date_String(N2)

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Bowers74]

KIS (keep it simple) ;-)

="not funded as of"&Text(N2,"mm/dd/yyyy&quot For the short date.

or

="not funded as of"&Text(N2,"mmmm d, yyyy&quot for the long date.

;-)







Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[dbpcar]

Thanks for all the possibilities, they all seem to work.