VBA - How to rename an Excel file based on the value in a Column

Hi,

I'm trying to rename a file based on two values in column A (Cell A2) and in column B (Cell B2). In my Excel spreadsheet, it has 3 columns:

Column A - Customer Name,
Column B - Giving Date (11/30/2020)
Column C - Giving Amount ($)

Column A has ONLY 1 customer (John Doe)
Column B has multiple dates (1/31/2020, 2/28/2020, 3/31/2020 etc.)

I need the VBA to create a new file with a different name. It should be in this format "2020.11.30_John Doe_Giving Statement"

The date must be the most recent date. Maybe sort it (descending) first?

Big thanks for your help!

-Dan