How do I calculate # of weeks between 2 dates in excel?

[Linda]

I need to figure out how to calculate future dates in excel in # of weeks.
Is there an easy way to do this?

 

[Anne Troy]

If you want to add a week to a date, just use =A1+7.
If you want to determine the number of weeks between two dates, just use
=(B1-A1)/7

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Bob Phillips]

Just subtract today's date from the future date and divide by 7.

If you only want whole weeks, INT it,

=INT((A2-TODAY())/7)

to the nearest week

=ROUND((A2-TODAY())/7,0)