How do I calculate the number of quarters between two date
 

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

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)


"Adam" <Adam @discussions.microsoft.com wrote in message
...
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