Forum Discussion
Formulas not interacting - COUNTIF looking at DATEDIF
Hello all, I have attached images of two formulas, the first looks at the start date of our customers and returns how long they have been with us. The second is on another sheet looking to determ...
Change the last part of the formula to:
VALUE(ys & "." & ms)Without the VALUE function it returns a text like "3.8" or similar. COUNTIF for values greater than 2 will not pick-up texts and return zero.
But why not just use:
=(TODAY()-V16)/365That will return a decimal number representing the number of years with decimals. 3 years and 8 months would then be 3.75