How do I calculate the number of quarters between two date

A

Adam

I want to input 2 dates and then calculaet the number of Quarters between
then just dividing by (365/4) wont deal with leap years
 
B

Bob Phillips

Depends upon what your rule is, for instance is 30th March to 7th July one
quarter, 2 or 3?

You can use Datedif to get the number of months, =DateDif(date1,date2,"m")
and perhaps divide by 3.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top