I want to sort events of a month with more than two days distance.Can anyone teel me how to do it in libreoffice calc?

asked 2018-08-28 05:57:41 +0200

cmitt10 gravatar image

updated 2018-08-28 10:46:47 +0200

Lupp gravatar image

I want to sort events of a month with more than two days distance.Can anyone teel me how to do it in libreoffice calc?

edit retag flag offensive close merge delete

Comments

The question is unclear in "with more than two days distance" part. What do you mean? You only need to sort events if they have at least that distance? You have data with that property? What difference does the distance make on the sorting process?

The general sorting in Calc (using DataSort) works fine for dates as well.

Mike Kaganski gravatar imageMike Kaganski ( 2018-08-28 06:04:03 +0200 )edit

"The general sorting in Calc (using Data→Sort) works fine for dates as well."... ...as long as either all of them are numeric spreadsheet dates or all of them are text dates in the same suitable format (best "YYYY-MM-DD": ISO 8601 extended).

Lupp gravatar imageLupp ( 2018-08-28 10:49:17 +0200 )edit