Hello.
Lets assume we have 7 days week and monday to friday are working days.
Now. Let's create 7 columns. For each column I will list workers that will do some job.
But what I want to achieve some autmation -
1# calculate that first column will be let's say always Monday.
May I use date today to fill seven columns autmatically (calculated)?
2# And the second question.
How to display holidays in this 7 columns based on earlier created list of dates?. I mean. For example I can do list of dates in separate hidden column - but then I want to have it in red in column if day is within observed week.
Lets assume we have 7 days week and monday to friday are working days.
Now. Let's create 7 columns. For each column I will list workers that will do some job.
But what I want to achieve some autmation -
1# calculate that first column will be let's say always Monday.
May I use date today to fill seven columns autmatically (calculated)?
2# And the second question.
How to display holidays in this 7 columns based on earlier created list of dates?. I mean. For example I can do list of dates in separate hidden column - but then I want to have it in red in column if day is within observed week.