This is how I did it…
StrFilePath = "Date\Gardeswild files mains abcdef as of 09-06-2021.xlsx"
From = "Date\Gardeswild files mains abcdef as of 09-06-2021.xlsx"
To = "Date\" + path.GetFileNameWithoutExtension(StrFilePath).split({"as of"},StringSplitOptions.RemoveEmptyEntries)(0) +"as of "+cdate(path.GetFileNameWithoutExtension(StrFilePath).split().Last).AddDays(1).ToString("MM-dd-yyyy") + ".xlsx"
path.GetFileNameWithoutExtension(StrFilePath).split({“as of”},StringSplitOptions.RemoveEmptyEntries)(0) → This will give me "Gardeswild files mains abcdef "
cdate(path.GetFileNameWithoutExtension(StrFilePath).split().Last).AddDays(1).ToString(“MM-dd-yyyy”) → This will give me “09-07-2021”
Final outptut
Hope this helps…