How to exclude from a calendar, a day of the week that is not Saturday and Sunday?

How to exclude from a calendar, a day of the week that is not Saturday and Sunday?

I need to set up a work week, which is not always Monday through Friday, I could also work Monday through Saturday or Sunday through Friday or whatever day I want to exclude.

Does anyone know a way?

regards

0 4 329
4 REPLIES 4

Calendar views are not feature rich. So it's just what you see on the editor, nothing else.

What you could do is create a custom view, there are some notable mentions around that

Good morning Oscar, perhaps I have not expressed myself well. I don't want the calendar view to have any function other than showing dates.

How do I exclude the days that I do not want? There is a formula to calculate business days between two dates excluding Saturdays and Sundays but this exclusion is very general (WORKDAY), I need something more particular 

What I need is to assign a working week in a form, say, you work:

Monday Wednesday and Friday

or

Saturdays and Sundays

or

Monday to Friday,

or

any combination I wanted.

I thank you in advance if you know any answer

You can make a slice to filter just the dates you want.

If it's just the mondays:

WEEKDAY([DateColumn])=2

If you want Mondays, Wednesdays and Fridays:

IN(
  WEEKDAY[DateColumn],
  LIST(2, 4, 6)
)

 

Agradezco mucho tu respuesta! estuve intentano hacer esto pero probablemente no me he expresado como corresponde. Tengo una App en la que deseo configurar una semana laboral. Una especie de Enumlist donde yo elijo los dรญas en que voy a ejecutar mi trabajo:

Domingo

Lunes

Martes

Miรฉrcoles

Jueves

Viernes 

Sรกbado

Todos se eligen mediante una casilla de check.

Una vez elegidos los dรญas tengo que elegir la fecha de inicio del trabajo. Supongamos que inicio hoy 16/3/2022 y que trabajarรฉ Lunes, Miรฉrcoles y Viernes. Ademas supongamos un plazo de 30 dรญas laborales. Ademรกs tengamos en cuenta dรญas feriados. Lo que yo necesito es poder calcular la fecha de finalizaciรณn del trabajo, teniendo en cuenta un plazo de 30 dรญas laborales, los dรญas feriados y la configuraciรณn de semana laboral previamente elegida. 

Esto me darรญa un resultado con una fecha 10 semanas mรกs tarde si no hay un feriado que coincida con algunos de los dรญas.

Una de las fรณrmulas que usรฉ es WORKDAY() sin embargo es limitada ya que solamente excluye de la lista a los sรกbados, a los domingos. 

ยฟExiste alguna manera de crear mi propia fรณrmula WORKDAY excluyendo los dรญas que yo quiera?

Top Labels in this Space