Ask Your Question

What is the formula in Google Sheets to arrange a list of dates in yearly intervals?

asked 2022-06-25 11:00:00 +0000

devzero gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2021-06-04 16:00:00 +0000

lakamha gravatar image

To arrange a list of dates in yearly intervals, you can use the YEAR function in combination with the SORT function in Google Sheets.

The formula would be:

=SORT(A1:A10, YEAR(A1:A10))

In this formula, replace A1:A10 with the range of the cells that contain your list of dates.

The YEAR function extracts the year from each date, and the SORT function sorts the dates based on the year in ascending order. This will arrange your list of dates in yearly intervals.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools


Asked: 2022-06-25 11:00:00 +0000

Seen: 10 times

Last updated: Jun 04 '21