Finding week from date

  • Thread starter Thread starter Chris
  • Start date Start date
C

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?

Chris
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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?
Click to expand...

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

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
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)
 
Back
Top