counting a period between two dates?

alinka

Board Regular
Joined
Oct 30, 2002
Messages
70
Hi,

I have a set of two dates - one date is when a lead (prospect) was received. And, another date is when this prospect actually became a client. I would like to calculate and analyze how long it takes for a lead/prospect to become a client. In years and months and days.... Which formula is best for that?

Thanks so much!
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi Alinka:

You can use ...
'=DATEDIF(A2,B2,"y")&" Years "&DATEDIF(A2,B2,"ym")&" Months "&DATEDIF(A2,B2,"md")&" days"
where A2 houses the earlier, and B2, the later date.
 

alinka

Board Regular
Joined
Oct 30, 2002
Messages
70
Dear Yogi,

This formula worked just great. It is absolutely perfect and exactly what I needed. I can't thank you enough. Thaaaaaaaaaaaaanks!!!!
 

IML

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,743
Just another twist, if you simply evaluate the days difference
=B2-A2
and apply a number or general format
you can then "analyze" these a little deeper - whether that be sorting, averaging, finding std deviation, etc.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,400
Messages
5,601,462
Members
414,451
Latest member
jrose7

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top