Can anyone tell me what this formula is calculating?

[antoszewskim]

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"))))

[gak67]

I'm not sure why it has the 0*7 part in there as that will always calculate to 0. What it is doing is calculating the date that is the number of days shown in cell B2 after 31 December 1899, unless B2 is more than 60 days in which case it is calculating the date that is one day earlier than the number of days shown in cell B2 after 31 December 1899. It is then comparing that calculated date to today's date and working out the number of days between those two dates. It is then dividing cell B5 by that number of days.

Why it is doing this though is impossible to say without context.

[antoszewskim]

I am confused as well by the 0*7 in the formula....since this will always be equal to 0

The context of the spreadsheet is as follows:
The spreadsheet is calculating the weight the baby has lost in the spreadsheet.
B5 = weight the child has lost in the past 7 days.
B2 = date the child was first weighed.

I can't understand why the formula is calculating how many days the date in B2 is after 31 December 1899.....what is that about?
Isn't there an easier way to calculate the difference between the date in B2 and today?

Wouldn't the following formula work:
DATEDIF(B2, TODAY(), "d")