Access week from a date

[vangoethem]

How to calculate the number of week from a given date?
It should something having to with "date-part".
I need it for a form.

regards

 

[SkipVought]

Well, each week is 7 days.

So....

EndDate = StartDate + NumberOfWeeks * 7

or am I missing something? Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[bandit600]

The original post could be ambiguous.

Skip's post should solve one interpretation.

But it could also be read as requiring to calculate the number of the week (in the year) from a given date, in which case the WeekNum function will do if installed.

For instance Weeknum(Today()) returns 10 signifying that today is in the 10th week of the year.

bandit600

 

[xlbo]

Yeh but what if the start date of the "year" is not 01/01
We have a financial year that starts in August - to calculate our financial weeks, I use:

=roundup((CurrentDate-StartDate) / 7)
for current week and
=roundup((CurrentDate-StartDate) / 7)-1
for the previous week
Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde