You can change the date format in Google Sheets and customize the appearance of calendar dates in a spreadsheet.
To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.