If for you "WEEK" is any 7 days then weeks = =INT((B2-A2)/7) and days =
=MOD((B2-A2),7)

But it gets complicated if WEEK is a 'calendar week'?
If so does your week begin on Sunday or Monday?
If we start on Tuesday of week 1 and end on Wednesday or week 2, how may
weeks will this be for you purpose? It is two partial weeks and no complete
weeks.

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Lisa D" <Lisa wrote in message
...
I need to create a formula where it calculates the number of weeks and days
between 2 dates.

For example:
A2 = 12/25/08
B2 = 1/30/09
C2 = 5 weeks 1 day

I found example formulas that calculates years, months and days....but no
weeks.

Any help is most appreciated!
Thanks!