If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can anyone provide me the fomula ?
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 fallD1 (answer shown in month and days. Ans = 5 yrs & 2 mths. Any solution ? Thanks. Thanks. |
#2
|
|||
|
|||
Can anyone provide me the fomula ?
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 "TQ" wrote in message ... 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 fallD1 (answer shown in month and days. Ans = 5 yrs & 2 mths. Any solution ? Thanks. Thanks. |
Thread Tools | |
Display Modes | |
|
|