| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show week number in current month
Hi, In cell A1 I have a "=today()" to show todays date in dd/mm/yy format, in cell B1, I would like to have have a number to represent the week number in the current month. So the 2/12/05 would show in B1 as "1" while 30/12/05 would show as "5". Using "=weeknum(A1)" gives me the week number against the whole year (ie - 53) for todays date. How can get B1 to show only 1 to 5 for the weeks in the current month only? -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=496942 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show week number in current month
=INT((DAY(A1)+7)/7)
assuming you are using a simple rule of days 1-7 are week 1, 8-14 week 2, .... -- HTH RP (remove nothere from the email address if mailing direct) "DKerr" wrote in message ... Hi, In cell A1 I have a "=today()" to show todays date in dd/mm/yy format, in cell B1, I would like to have have a number to represent the week number in the current month. So the 2/12/05 would show in B1 as "1" while 30/12/05 would show as "5". Using "=weeknum(A1)" gives me the week number against the whole year (ie - 53) for todays date. How can get B1 to show only 1 to 5 for the weeks in the current month only? -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=496942 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show week number in current month
Thanks, That works perfectly -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=496942 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show week number in current month
Bob, I tried this, and it puts the 7th day into week 2. Is there some way to
keep 1-7 as week 1? "Bob Phillips" wrote: =INT((DAY(A1)+7)/7) assuming you are using a simple rule of days 1-7 are week 1, 8-14 week 2, .... -- HTH RP (remove nothere from the email address if mailing direct) "DKerr" wrote in message ... Hi, In cell A1 I have a "=today()" to show todays date in dd/mm/yy format, in cell B1, I would like to have have a number to represent the week number in the current month. So the 2/12/05 would show in B1 as "1" while 30/12/05 would show as "5". Using "=weeknum(A1)" gives me the week number against the whole year (ie - 53) for todays date. How can get B1 to show only 1 to 5 for the weeks in the current month only? -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=496942 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show week number in current month
How about:
=INT((DAY(A1)-1+7)/7) Joe wrote: Bob, I tried this, and it puts the 7th day into week 2. Is there some way to keep 1-7 as week 1? "Bob Phillips" wrote: =INT((DAY(A1)+7)/7) assuming you are using a simple rule of days 1-7 are week 1, 8-14 week 2, .... -- HTH RP (remove nothere from the email address if mailing direct) "DKerr" wrote in message ... Hi, In cell A1 I have a "=today()" to show todays date in dd/mm/yy format, in cell B1, I would like to have have a number to represent the week number in the current month. So the 2/12/05 would show in B1 as "1" while 30/12/05 would show as "5". Using "=weeknum(A1)" gives me the week number against the whole year (ie - 53) for todays date. How can get B1 to show only 1 to 5 for the weeks in the current month only? -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=496942 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating the number of Fridays in a month | Excel Worksheet Functions | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
| Dynamic Column VlookUps Based on Week Number | Excel Worksheet Functions | |||
| Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions | |||
| Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions | |||
Linear Mode
