Hi
I have this code
at /7)*7 I can add a +2 for Monday and so on, but i'm getting some error with sunday because it's the first day in a week, i get wrong weeknumbers for that day/dates.
So i need to add the Return_Type 11 so monday is the first day of a week.
But where do I add it and how ?
I have this code
Code:
[COLOR=#333333]=IFERROR(MATCH(INT(DATE(YEAR(year!$B$2);1;-2)/7)*7+2+AG5*7;year!$B$6:$B$40;0);"")[/COLOR]
at /7)*7 I can add a +2 for Monday and so on, but i'm getting some error with sunday because it's the first day in a week, i get wrong weeknumbers for that day/dates.
So i need to add the Return_Type 11 so monday is the first day of a week.
But where do I add it and how ?