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...
I'm not sure if this is what is meant, but here is a simple example in the attached file that should work in all versions of Excel, since there is no information about the version.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Hi Niko, your formula probably depends on your system date settings. It returns #VALUE! on my computer too.
- NikolinoDE that is a clever way to do it. Maybe use the ISO standard for the date format then it may be more universal (year-month-day):
=(B2&-1&-1)+A2*7-MOD(B2&-2&-1,7)-4
HansVogelaar and SergeiBaklan can you confirm if this version works for you too?
