*Subject:* Re: $$Excel-Macros$$ Formula to Calculate Weeks
Hi Paul,
is the reason one would divide by 7 is because there is 7 days in a week?
Susan
On Thursday, December 6, 2012 7:58:00 AM UTC-8, Paul Schreiner wrote:
WEEKS is easy.
Keep in mind that Excel dates are simply numbers
Wesley
-
From: Sunnie sunni...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wed, December 12, 2012 9:56:22 PM
Subject: Re: $$Excel-Macros$$ Formula to Calculate Weeks
Hi Paul,
is the reason one would divide by 7 is because
*-
--
*From:* t vinay vinay...@gmail.com javascript:
*To:* excel-...@googlegroups.com javascript:
*Sent:* Thu, December 6, 2012 10:19:25 AM
*Subject:* $$Excel-Macros$$ Formula to Calculate Weeks
Hi Team,
can you please help me with a formula
, 2012 1:32:24 AM
Subject: Re: $$Excel-Macros$$ Formula to Calculate Weeks
Hi,
=WEEKNUM(Future date,2)-WEEKNUM(today(),2)
Weeknum gives number of week
you can change option (2) in formula as per your requirement, formula will
prompt you when you enter formula.
If this works otherwise tell us
Hi Team,
can you please help me with a formula to calculate the number of weeks from
today to a future date.
--
Regards,
Vinay. T
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
$$ Formula to Calculate Weeks
Hi Team,
can you please help me with a formula to calculate the number of weeks from
today to a future date.
--
Regards,
Vinay. T
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread
http://www.exceltip.com/st/Calculating_Number_of_Days,_Weeks,_Months_and_Years_between_Dates/915.html
On Thu, Dec 6, 2012 at 8:48 PM, t vinay vinaytu...@gmail.com wrote:
Hi Team,
can you please help me with a formula to calculate the number of weeks
from today to a future date.
--
vinay vinaytu...@gmail.com
Subject: $$Excel-Macros$$ Formula to Calculate Weeks
To: excel-macros@googlegroups.com
Date: Thursday, December 6, 2012, 8:48 PM
Hi Team,
can you please help me with a formula to calculate the number of weeks from
today to a future date.
--
Regards,
Vinay. T