This formula will calculate how many days
=DATEDIF(Date1,Date2,"d")

or =DATEDIF(A1, B1,"d") with dates in A1 and B1

If by week you mean any seven days (not a Sun to Sat) then
=DATEDIF(A1, B1,"d") /7

best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Shihachi" wrote in message
...
I was wondering if there is a formula to calculate how many weeks it is
from
today to a certain date