T
TQ
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.
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.