diego alvarez

Options

Hello! I would like to know if somebody can help me with one formula. I have to do one formula that show the monday's of the all weeks about other date.

Here is an example:



Answers

  • TravisK
    TravisK ✭✭✭
    Options

    Hello,

    Try this:

    =WORKDAY([Fecha inicio de semana]@row - WEEKDAY([Fecha inicio de semana]@row - 1), 1)

    Explanation:

    WEEKDAY() returns the numeric day of the week. 1=Sunday, 7=Saturday.

    [Fecha inicio de semana]@row - WEEKDAY([Fecha inicio de semana]@row - 1) Finds the prior Sunday.

    WORKDAY(date, 1) finds the first working day (Monday-Friday) after the Sunday.

    -Travis

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!