Prev: Formula From: TQ on 6 Jun 2010 12:10 Hi, I need the fomula for below scenario, A4 = start date (exp.= 01.03.2007) B4 = end date (exp. = 31.05.2012) D1 = 01.04.2007 D2= 31.03.2008 E1= 01.04.2008 E2= 31.03.2012 F1 = >31.03.2012 at D4 = fomula to get the answer of days which fall between A4 & B4? (365days) D4 = fomula to get the answer ? (1460days) G4 - total period which date fall>D1 (answer shown in month and days. Ans = 5 yrs & 2 mths. Any solution ? Thanks. Thanks. From: Don Guillett on 6 Jun 2010 12:27 Analysistoolpak addin must be installed =DATEDIF(A4,b4,"y")&" yrs "&DATEDIF(A4,b4,"ym")&" mths" =DATEDIF(A4,B4,"d") -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "TQ" wrote in message news:2024AA7E-436E-4C64-9116-E8359CAE3D08(a)microsoft.com...> Hi, I need the fomula for below scenario, > > A4 = start date (exp.= 01.03.2007) > B4 = end date (exp. = 31.05.2012) > D1 = 01.04.2007 > D2= 31.03.2008 > E1= 01.04.2008 > E2= 31.03.2012 > > F1 = >31.03.2012 > > at D4 = fomula to get the answer of days which fall between A4 & B4? > (365days) > D4 = fomula to get the answer ? (1460days) > > G4 - total period which date fall>D1 (answer shown in month and days. Ans > = > 5 yrs & 2 mths. > > Any solution ? Thanks. > > > > Thanks. > >  |  Pages: 1 Prev: Formula