Hi, I would like to use the week number to decrease the percentage by 2% every week.
I have the date in B3,Time in D3, Week Number in F3,and 100% in H3.
The date,Time,Week number update and run whenever the computer is switch on.
Workbook opening script:Private Sub Workbook_Open()...