 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007An old subject Weeknum
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())&")"  SignatureKind 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)&")" SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog >I would like to show week numbers inside a cell that also contains the date >e.g [quoted text clipped - 4 lines] > > Mark 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 > Mark > [quoted text clipped - 18 lines] > > > > Mark Mark Great, glad one worked SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS 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 [quoted text clipped - 31 lines] >> > >> > Mark |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.