Concatenate date range

jenno1969

New Member
Joined
Jul 10, 2006
Messages
32
I'm trying to create a title page with a date range dependant on two cell values.

Cell A1 = 01/01/2008
Cell A2 = 01/01/2008


Eg. Sales Report for 1st January 2007 to 1st January 2008.

I've tried:-

Concatenate("Sales Report for ",A1," to",A2,".")

However when using concatenate the dates is in sequential code rather than date format. How do I overcome this?
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

VoG

Legend
Joined
Jun 19, 2002
Messages
63,651
Try

="Sales Report for "&TEXT(A1,"d mmmm yyyy")&" to "&TEXT(A2,"d mmmm yyyy")
 

Watch MrExcel Video

Forum statistics

Threads
1,095,782
Messages
5,446,468
Members
405,403
Latest member
horace james

This Week's Hot Topics

Top