Re: First day of week-Monday.

Hello,

The below formula returns 15.05.06. What is wrong with it?


=TODAY()-WEEKDAY(TODAY()-2)

will return the same dates

--

Regards,

Peo Sjoblom

=TODAY()-WEEKDAY(TODAY()-2)

Hi, I am unsure as to what you need, but what I understand from your formula above,

eg. today's date is 22/05/06

when u do a weekday(today()-2) function, the sresulting day is a saturday (since 20/05/06 was a Saturday. A weekday function expresses any date into a day of the week, given a format. Since you did not specify any format, it takes Sunday to be 1, and Saturday to be 7. Thus, WEEKDAY(TODAY()-2) returns 7.

Thus, the formula results in 15/05/06 because the formula evaluates into 22/05/06 - 7.