G Guest Jul 1, 2005 #1 I need to figure out how to calculate future dates in excel in # of weeks. Is there an easy way to do this?
I need to figure out how to calculate future dates in excel in # of weeks. Is there an easy way to do this?
A Anne Troy Jul 1, 2005 #2 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
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
B Bob Phillips Jul 1, 2005 #3 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)
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)
