diego alvarez

DiegoAlvarez.se

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:

TravisK

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