Or, more simply:
=(now()-b2)/7

Today is probably a better function to use for this purpose than Now:
=(today()-b2)/7

Regards,
Fred

"Jenn247" wrote in message
...
My daughter just helped me find it... =(DATEDIF(B2,NOW(),"d"))/7
Thanks anyway.

"Jenn247" wrote:

Can someone please advise me of a formula that would automatically update
the
number of weeks from a list of dates to the current date?