B75 reads "+1279 + 1"
B76 reads "+1290"
F75 should read "87 months" in other words, 1279 days, plus 1 day, plus 1290 days equals 2570 days. Divide that by a lunar month (29.5306 days) equals 87.0284 months.
I have custom formatted F75 to leave out the decimal points and to place "87 months" but I cannot automatically add up to 87.
Also, I need to fill down the "F" column so that this formula keeps repeating adjacent to its respective cells in "B" column.
|