import openpyxl as op import datetime as dt
wb = op.load_workbook("Date_format.xlsx") ws = wb["Sheet1"]
your_date = ws.cell(row=1, column=1).value your_formatted_date = your_date.strftime("%d-%b-%y") print(your_formatted_date)
22-Nov-21