Help!! - Microsoft Community

afternoon all,

wondering if there quick way in can edit absence form want use @ work? called bradford factor , tracker takes 1's (which indicate absence) still set 2016. have changed dates @ top correct working days , done same on user input screen. however, formulas on tracker relates individual date boxes on user input form not easy copy across new dates due $ in each one. there on 6,000 cells , don't want manually edit them all!

there can do? 

above absence recorded number 1. 

below tracker. formula in cell c2 needs relating f10, not f15 have last year...

way change formula depends on other formulas - in d2, , in c3?

Office / Excel / Windows other / Office 2016