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