I need some changes on an excel worksheet(macro) because it doesn’t not correctly calculate outputs if I use file in database with a date beyond the actual day:
1. Let the macro works also for dates beyond the actual day.
Use the file name of worksheet in database to understand the date of the most recent file, their name is always in this format: YYYY-M-DD (2022-8-23) or in cell E4.
Use this information for calculate on SOSTITUZIONI sheet the value “Giorni da ultima sostituzione” instead then actual date.
2. On SOSTITUZIONI sheet Divide(split) with a white line, or something else that is belived a better solution, the field between two persons histogram.