THANK YOU, THANK YOU, THANK YOU! With all the information you have shown me here and using the CPAN info for strptime and strftime, I've got my date displaying correctly now in my spreadsheet. What a pain!
Here is the final code that did it. I had to do some manipulating to get it to finally work. Incidently, the raw date I was using from the text file is a Julian calendar date. I generated it from a mainframe job that outputs a set of commands to a text file.
my $dfile = 'd1528235.txt';
open my $dfh, '<', $dfile;
my $date;
while ( <$dfh> ) {
chomp;
if ( not $date and $date = join '/', /=\((\d\d)(\d\d)(\d\d)/ ) {
my $str1 = '$date';
my $date1;
$date1 = Time::Piece->strptime($date, '%D, %M, %dhd, %Y') ;
my $date2 = $date1->strftime("%A %b %d, %Y");
$worksheet->merge_range('A2:G2',$date2,$format5,);