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
|