How many quarters between two dates?

[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!

 

[JMay]

try:
=DATEDIF(MIN(A3:A8),MAX(A3:A8),"m")/3

 

[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.)

 

[Dave Peterson]

This =datedif() will return an integer.

3.5 won't ever happen.

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

 

[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!
: