Calculate expiry clock for membership ( Remaining duration between two dates)

[xcfeng95]

Dear all,


Please give me formula to Calculate expiry clock for membership ( Remaining duration), with dates Y/M/D all separated in 3 cells. The excel file is attached in this post, you can understand the problem better by looking at the sheet and answer there!


Thank you all very much in advance, I will give your all stars if you experts help give me the answers!



1. (Urgent)

Question: Formula to find remaining duration( in months or days unit) between two dates.
Detail: the two dates, are both in 3 separate cells as Y/M/D, (instead of the date in the 1 cell) , e.g
Today's Date: Y/M/D ( in 3 separate cells) : 2014(year)=A3, 2(month)=B3, 20(day)=C3
membership start Date:Y/M/D ( in 3 separate cells) : 2011(year)=B10, 3(month)=C10, 4(day)= D10

Membership rule: 3 year period.

Answer:
with the rule of 3 years membership( 2014-2011 is 3 year period);
so to calculate the expiry clock(remaining duration) between today's date and contract ending date: is 0.39 in months, and 12 in days. but whats the excel formula for them?


The excel sheet is attached in this post, you can insert the formula in the sheet or in the post here.


2. ( Can reply later)
Problem: An auto update formula for today's date (in Y/M/D , 3 cell format)

[p24leclerc]

See attached workbook for answers to your 3 questions.