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

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

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


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

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)

--
HTH

Bob Phillips

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