Change sunday to monday in excel

[nfpk]

Hi!
I´ve got an excel sheet as a calendar.
With sunday- saturday on each row.
And a month per sheet.
I want to start every week with monday, how do I change the code?

=OM(MÅNAD(StartDate)<>MÅNAD(StartDate-StartDOW+Week*7+Weekday-1);&quot;&quot;;StartDate-StartDOW+Week*7+Weekday-1)

 

[ETID]

This formula will always return the date of the monday of the current week....(week begining with Sunday).

You can change the &quot;now()&quot; to a cell ref to test it out.




=MONTH(NOW())&&quot;/&quot;&DAY(NOW())-(WEEKDAY(NOW())-2)&&quot;/&quot;&YEAR(NOW())