Hi

=INT((Date2-Date1)/7)
gives the number of full weeks
=MOD(Date2-Date1,7)
gives number of remaining days


--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"WARRENCHERYL" wrote in message
...
What is the formula for calculating the number of weeks between two given
dates which may be in different years eg 10.01.2002 and 14.05.2004