Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DATETABLE

Hola He creado una tabla de fechas usando Tabla: ADDCOLUMNS(CALENDARAUTO(),"MONTH",MONTH([Date]),"Year",YEAR([Date])) ¿Cómo obtengo el último día de trabajo para cada uno de los meses?
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hola

    ¿Funciona?

    ADDCOLUMNS(CALENDARAUTO(),"MONTH",MONTH([Date]),"Year",YEAR([Date]),"Last working day",EOMONTH([Date],0)-if(WEEKDAY(EOMONTH([Date],0),2)<-5,0,if(WEEKDAY(EOMONTH([Date],0),2)-6,1,2))

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hola

¿Funciona?

Tabla: ADDCOLUMNS(CALENDARAUTO(),"MONTH",MONTH([Date]),"Year",YEAR([Date]),"Last date",EOMONTH([Date],0))