I think this is a good website for the formula - https://www.epochconverter.com/weeks/2020
All weeks for US start on Sunday and end on Saturday.
Yes we should deal with the 53 weeks in a year. If we can create a formula with a from date and to date maybe that will work well.
This helps. If I may ask one more question. I currently have a TRIR Year table and a TRIR Weeks table. Given your solution, and your first sentence with regards to setting up a new table with a single record for automation focus? – should that be a new table or should I use the TRIR year table?
My workflow for the user would be:
Before I begin, I just wanted to clarify this. Do you see using 2 tables or 3 total.
Director of Operational Excellence (OpEx)