If I enter a date in AF4 I need it to count as 1 and I want to multiply it by AC4 and my formula is going to be a few of these adding them
together then I want to *100
Like this...
=((AF4*AC44)+(AF5*AC5)+(AF6*AC6)+(AF7*AC7))*100
But how do I get it to count the date as a number in the AF column?
together then I want to *100
Like this...
=((AF4*AC44)+(AF5*AC5)+(AF6*AC6)+(AF7*AC7))*100
But how do I get it to count the date as a number in the AF column?