Finding week from date
 

I need to find the actual week from a date. If a date is
eg. 17.02.2004 it should return 7. Is there a function or
calculator?

Chris

Finding week from date
 

You might want to look he

http://www.cpearson.com/excel/weeknum.htm

Chip Pearson's page on ISO weeknumbers and Excel's weeknum function.

--
Regards,
Tom Ogilvy

"Chris" wrote in message
...
I need to find the actual week from a date. If a date is
eg. 17.02.2004 it should return 7. Is there a function or
calculator?

Chris

Finding week from date
 

Hi Mike!

You appear to be using the week numbering system where Jan-1 is start
of week 1 and Jan-8 is start of week 2 etc.

This gives you the formula:

=INT((A1-DATE(2004,1,1))/7+1)

Or to make it flexible for the current year:

=INT((A1-DATE(YEAR(TODAY()),1,1))/7+1)

But see:

Chip Pearson:
http://www.cpearson.com/excel/weeknum.htm

Discusses week numbering
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Chris" wrote in message
...
I need to find the actual week from a date. If a date is
eg. 17.02.2004 it should return 7. Is there a function or
calculator?

Chris

Finding week from date
 

Hi Chris,

I need to find the actual week from a date. If a date is
eg. 17.02.2004 it should return 7. Is there a function or
calculator?


Activate the analysis toolpak addin (Tools, addins) and then use the
Weeknumber function.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Finding week from date
 

Chris,

Not as simple as it at first sounds. Check out this previous post from
Norman Harker, it gives good detail

http://tinyurl.com/2xlg5


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Chris" wrote in message
...
I need to find the actual week from a date. If a date is
eg. 17.02.2004 it should return 7. Is there a function or
calculator?

Chris