Make automation perpetual on a reporting database. currently restricted by year!

I have developed a CRM system using Excel and have learned a lot along the way. Lots of VBA

I have a sales sheet, with the dates of sale recorded in column 2. In column 1, I convert the date of sale into a week number (corrected for our trading year feb - feb), I then use the week number as a unique identifier to perform other functions (such as reporting). This requires that at the start of every year, I go through all of my scripts and only refer to the range in the sales sheet that refer to the correct year, otherwise I would have similar weeks from different years clashing.

Is there a simple way that I can resolve this? Im not even sure that my current workaround for the weeknum conversion is efficient (take a look at column 1 on "Sales Log")

There is a hidden sheet called "Settings also".

Would someone mind taking a look (attached) so that we can be on the same page, then maybe I can explain further if needed?

Password is "Miami"

Sensitive data removed!

Hi
I suppose you can create a key using the year and the week number.
Try in SalesLog!B5 the following formula and drag down

Formula:

Please Login or Register  to view this content.

Note: I could not see how you calculate the number of weeks.