资讯

You can change the date & time format in Google Sheets & Excel Online using this guide. Use different date & time formats in spreadsheets.
How to return a sequence of dates in Excel Excel’s fill handle can generate a quick list of dates for you, but the list is static; you must create a new list if your needs change.