B8 = 10/15/06
J3 = 09/30/07
The formula below computes 13 months, but I need it to calculate 12.5 months.
=(YEAR($J$3)-YEAR(B8))*12+MONTH(B8)-MONTH($J$3)
Does anyone know how I can calculate the 12.5 months?
B8 = 10/15/06
J3 = 09/30/07
The formula below computes 13 months, but I need it to calculate 12.5 months.
=(YEAR($J$3)-YEAR(B8))*12+MONTH(B8)-MONTH($J$3)
Does anyone know how I can calculate the 12.5 months?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks