Can you tell me what the denominator of this equation is calculating. Specifically the section of the formula that says (1899,12,31)+(0*7+IF(B2>60,B2-1,B2))),
The column is labeled change per day.
=(B5/((DATEDIF((DATE(1899,12,31)+(0*7+IF(B2>60,B2-1,B2))),TODAY(),"D"))))
Bookmarks