Microsoft Office Forums - View Single Post - Concatenate to reference values with that are dates

Thread: Concatenate to reference values with that are dates

View Single Post

Old

08-02-2018, 03:53 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Maybe try...

=TEXT(A29,"MM/D/YYYY")&" - "&TEXT(A33,"MM/DD/YYYY")

Reply With Quote