Forum Discussion
split or create a funtion
hello everyone, i have a problem to put automaticaly range of daily works, and that is slowly to me So that I want to create a function or have help how to do it. like in semaine 53 = I want to th...
How about
=LET(Sep_1, DATE(YEAR(TODAY())-(MONTH(TODAY())<9), 9, 1), Wk, TEXTAFTER(A2, " "), Dt, Sep_1+7*Wk, Mon, Dt-WEEKDAY(Dt, 3), Sun, Mon+6, TEXT(Mon, "dd/mm/yy")&"-"&TEXT(Sun, "dd/mm/yy"))
=LET(Sep_1; DATE(ANNEE(AUJOURDHUI())-(MOIS(AUJOURDHUI())<9); 9; 1); Wk; TEXTE.APRES(A2; " "); Dt; Sep_1+7*Wk; Mon; Dt-JOURSEM(Dt; 3); Sun; Mon+6; TEXTE(Mon; "jj/mm/aa")&"-"&TEXTE(Sun; "jj/mm/aa"))