Hello everyone,
is it possible to dynamically distribute given range of dates within a year which is two times smaller than the range I need to assign it to?
Let's say I have 750 locations and upcoming year has 260 work days. I need to split the dates to items to cover the whole year, so each date gets multiplied and assigned to each unique location. It would be great if it also incorporates current date and does it dynamically (e.g. a macro), but static distribution will do.
It is a working plan to show superiors what is to be or should be done and when.
So far, I have a list of work days, and that's where I ended trying & failing.
Hopefully there is a way...
Jirka
A sheet:
dates.xlsx
Bookmarks