You can change the date & time format in Google Sheets & Excel Online using this guide. Use different date & time formats in spreadsheets.

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

Excel’s Date filters are very comprehensive and allow you to extract individual or multiple dates by day, week, month, year, quarter, or year-to-date, plus dates within ranges.

How to get a yearly balance in Excel Our simple data set has transactions for only one year, 2020, but that doesn’t matter. We can expect only one balance for the data set.