I am trying to show the number of days, months and years between todays date and a series of dates which have either expired or will expire in the future. However, I need one formulae that will calculate positive and negative time eg:


Todays Date Contract date Time until expirey/past expirey
21//09/2010; 1/11/2010; 0 years 1 months 11 days
21/09/2010; 20/08/2010; 0 years -1 months - 1 days
21/09/2010; 22/09/2010; 0 years 1 month 1 days

Please can somebody help!