An old subject Weeknum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to show week numbers inside a cell that also contains the date e.g
In cell A1 "01/01/2007 (1)" (1) being the weeknumber for that date, hope
this makes sense, I have looked all over many of MVP website and can not find
a workaround.

Mark
 
Hi Mark,

=TEXT(TODAY(),"dd/mm/yyyy")&" ("&WEEKNUM(TODAY())&")"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I would like to show week numbers inside a cell that also contains the date e.g
| In cell A1 "01/01/2007 (1)" (1) being the weeknumber for that date, hope
| this makes sense, I have looked all over many of MVP website and can not find
| a workaround.
|
| Mark
|
 
Mark

I'm sure this isn't what you want, as the date is hard coded, but it will
give you the format you want. If not then consider using a hidden column
with the dates, then it's a cinch.

Hard coded

="01/01/2007 ("&WEEKNUM(DATEVALUE("01/01/2007"))&")"

Hidden column A (and copy down)

=TEXT(A1,"dd/mm/yyyy")&" ("&WEEKNUM(A1)&")"

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 
Perfect, this is for other people to view, they enter a specfic date of work
completed, but work on a week number basis. I.e the question always is "what
week was that"

Many thanks

Mark
 
Back
Top