Forum Discussion

null null's avatar
null null
Copper Contributor
Mar 04, 2018

Custom list

Hello! I want to know if it is possible to do an automatic custom list with every tuesday and thursday of 2018.

Thanks in advance.

Javier.

Custom List
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Mar 05, 2018

    Hi Javier,

     

    Depends on what do you mean under automatic.

    As variant

    - put in A1 the date January 02, 2018 (in your date format) which is first Tue in 2019

    - in A2

    =WORKDAY.INTL(A1,1,"1010111")

    - drag (copy) A2 down till last desirable date

     

Resources