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...
Above all date range has 6 days difference but for 53 you different logic. If logic remain same than you can use the below formula.
=LET(dt,RIGHT(M7,8),TEXT(dt+1,"dd/MM/YY")&"-"&TEXT(dt+7,"dd/mm/yy"))
- you have 2 = signs. remove 1 of the "="
