How many quarters between two dates?

R

Rich9016

Hi Everyone!

Got a date question for you. I was wondering if anyone knew of
formula where I could do the following:

Withing a column, find the oldest date, and the most recent dat
listed. Then, find out how many quarters (three months) fell betwee
those dates.

Anyone know?? Any help is of course greatly appreciated. Thanks!
 
D

Dave Peterson

Chip Pearson has a nice web page that documents the =Datedif() function (not in
xl's help except for xl2k).

Look here:
http://www.cpearson.com/excel/datedif.htm

Then you could use it to return the number of months:
=DATEDIF(MIN(A:A),MAX(A:A),"m")

Then adjust it for the quarter.
=ROUNDUP(DATEDIF(MIN(A:A),MAX(A:A),"m")/3,0)
(I rounded up. 3.5 months = 2 qtrs.)
 
D

Dave Peterson

This =datedif() will return an integer.

3.5 won't ever happen.

But 4 months = 2 quarters using =roundup().
 
R

Rich9016

thanks guys, this was really helpful. I've bookmarked chip's site an
used the formula jmay gave me. You guys are the best, thanks again!
:
 
Top