TOP

Mark weekends

Date > Mark weekends

Marks dates in red in the selected cell range according to user-selected days of the week as weekend days (usually Saturday and Sunday).

This tool allows for quick visual identification of weekend days in a date column, which is especially useful for scheduling, tracking work hours, or analyzing time series. It applies formatting without the need to manually create complex conditional formatting formulas for each cell.


Screenshot

Date > Mark weekends

After applying:

Date > Mark weekends

Launching this tool

Click YLC Utilities > Date > Mark weekends :

YLC Utilities > Date › Mark weekends
YLC Utilities > Date › Mark weekends

How much time will it save?

By using this tool, you are guaranteed to save time and effort. However, the actual time savings depend on how often you use Excel (Calc), the volume of data you are working with, and how often you use this tool.

Download the extension

You can use the Mark weekends utility by installing the YLC Utilities extension.

After that, this function will be available in all files that will be opened in Excel (LibreOffice Calc).


Additional keywords for this tool:
Mark weekends, highlight dates, weekend days, date formatting

The YLC Utilities menu in LO Calc

The YLC Utilities menu in LO Calc

The YLC Utilities menu in Excel

The YLC Utilities menu in Excel