I'm trying to get a couple of Dates to be included in a cell with some text and the results is displaying incorrectly.
This is the formula I'm using:-
=C3&" Expires Between "&C4&" "&MIN(TrafficFirst!A4:A15)&" To "&MAX(TrafficFirst!A4:A15)
This is the desired result:-
"Packets Expire between Apr 2006 To March 2007"
This is what is being shown:-
First Class Yorks 38808 To 39142
Can anyone please assist?
This is the formula I'm using:-
=C3&" Expires Between "&C4&" "&MIN(TrafficFirst!A4:A15)&" To "&MAX(TrafficFirst!A4:A15)
This is the desired result:-
"Packets Expire between Apr 2006 To March 2007"
This is what is being shown:-
First Class Yorks 38808 To 39142
Can anyone please assist?