Assuming the last service date is in A1, the number of months until the next
service date is in B1, enter in C1

=DATE(YEAR(A1),MONTH(A1)+B1,DAY(B1))

to get the next service date

and in D1
=DATEDIF(TODAY(),C1,"M")&" Months,
"&INT((EOMONTH(TODAY(),0)-TODAY()+DAY(C1))/7)&" Weeks,
"&ROUND(MOD((EOMONTH(TODAY(),0)-TODAY()+DAY(C1))/7,1)*7,0)&" Days"

to get the number of Months,Weeks,Days. Try it out and see if it gives the
results you want.


"elusiverunner" wrote:

I have a worksheet where I enter data on a weekly basis - (car servicing) at
present I have been able to total the distance travelled since the last
serviced. What I would like to be able to do is display how much time - (in
months, weeks and days) till the next service interval, knowing that each
service interval is three months or six months hence. In other words count
down the time from previous service to next service.

Can someone, firstly tell me if it can be done and secondly how can it be
done ??
--
Steven.

In God we trust, all others we virus scan.