i have a formula in excel
= (50/-10000) *30.4/(Z2-Y2)
when eh we work on dec data Z2-Y2 shd be nov - sep
sso the result shd be 30 days
can anyone help
This would depend on your data structure, but in general the formula is exactly the same. Substitute the variable names in place of Z2 and Y2.