Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Returning the Week Number of a Specific Date on a Month
hi! It's me again I just wanna ask, for example i have this data 10/21/2004 3:02:08 PM How will I remove the the time value? And for the same date, How will I return the week number of that date on that month. On the example date, 10/21/2004 is on week 2 of October... Thanks a lot for your help! -- arjcvg ------------------------------------------------------------------------ arjcvg's Profile: http://www.excelforum.com/member.php...o&userid=12713 View this thread: http://www.excelforum.com/showthread...hreadid=274756 |
#2
|
|||
|
|||
You can remove the time component with INT(A1)
as for which week, it depends on where you are and even what it applies to. In the US it would be WEEKNUM Worksheet Function which is described on Chip's page, but for outside the US you might have to use something else even though there are option on the WEEKNUM Worksheet Function. Take a look at Chip Pearson's page Week Numbers In Excel http://www.cpearson.com/excel/weeknum.htm Use of your name and written English would be appreciated. -- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "arjcvg" wrote in message ... hi! It's me again I just wanna ask, for example i have this data 10/21/2004 3:02:08 PM How will I remove the the time value? And for the same date, How will I return the week number of that date on that month. On the example date, 10/21/2004 is on week 2 of October... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to extract month number from month name | Excel Discussion (Misc queries) | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
how to get week number in month in excel ? | Charts and Charting in Excel | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) |