Can anyone provide me the fomula ?

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.
 
D

Don Guillett

Analysistoolpak addin must be installed
=DATEDIF(A4,b4,"y")&" yrs "&DATEDIF(A4,b4,"ym")&" mths"
=DATEDIF(A4,B4,"d")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round up & Autosum 1
checking two different cells 1
Pivot Table (vlookup 2 column text values, return 1 value) 1
How to use SUMIF to return sums between two values located in cells 1
Find greatest value with VBA 1
remove duplicate rows from specific data in a column; excel 2007 1
Summarising large amt of data across sheets 5
Locating Matches & Highlighting Background 2

Top