View Single Post
 
Old 01-13-2017, 09:11 PM
Cyberseeker Cyberseeker is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: Jun 2016
Posts: 44
Cyberseeker is on a distinguished road
Default

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.
Reply With Quote