Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Week Of Month
Hi, trying to figure out a formula to populate column c, where it would
reflect the week of the month. This would be calculated off the value in column A. Please help. Thanks, Emilio A B C 11/1/2007 Thursday 1 11/2/2007 Friday 1 11/3/2007 Saturday 1 11/4/2007 Sunday 2 11/5/2007 Monday 2 11/6/2007 Tuesday 2 11/7/2007 Wednesday 2 11/8/2007 Thursday 2 11/9/2007 Friday 2 11/10/2007 Saturday 2 11/11/2007 Sunday 3 11/12/2007 Monday 3 11/13/2007 Tuesday 3 11/14/2007 Wednesday 3 11/15/2007 Thursday 3 11/16/2007 Friday 3 11/17/2007 Saturday 3 11/18/2007 Sunday 4 11/19/2007 Monday 4 11/20/2007 Tuesday 4 11/21/2007 Wednesday 4 11/22/2007 Thursday 4 11/23/2007 Friday 4 11/24/2007 Saturday 4 11/25/2007 Sunday 5 11/26/2007 Monday 5 11/27/2007 Tuesday 5 11/28/2007 Wednesday 5 11/29/2007 Thursday 5 11/30/2007 Friday 5 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Week Of Month
=WEEKNUM(A1)-WEEKNUM($A$1)+1
copy down as far as needed "Emilio S." wrote: Hi, trying to figure out a formula to populate column c, where it would reflect the week of the month. This would be calculated off the value in column A. Please help. Thanks, Emilio A B C 11/1/2007 Thursday 1 11/2/2007 Friday 1 11/3/2007 Saturday 1 11/4/2007 Sunday 2 11/5/2007 Monday 2 11/6/2007 Tuesday 2 11/7/2007 Wednesday 2 11/8/2007 Thursday 2 11/9/2007 Friday 2 11/10/2007 Saturday 2 11/11/2007 Sunday 3 11/12/2007 Monday 3 11/13/2007 Tuesday 3 11/14/2007 Wednesday 3 11/15/2007 Thursday 3 11/16/2007 Friday 3 11/17/2007 Saturday 3 11/18/2007 Sunday 4 11/19/2007 Monday 4 11/20/2007 Tuesday 4 11/21/2007 Wednesday 4 11/22/2007 Thursday 4 11/23/2007 Friday 4 11/24/2007 Saturday 4 11/25/2007 Sunday 5 11/26/2007 Monday 5 11/27/2007 Tuesday 5 11/28/2007 Wednesday 5 11/29/2007 Thursday 5 11/30/2007 Friday 5 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Week Of Month
Sandymann, thanks it worked.
Teetless, i don't think excel has a "weeknum" function, or at least my version (2003) doesn't. But thank you! "Teethless mama" wrote: =WEEKNUM(A1)-WEEKNUM($A$1)+1 copy down as far as needed "Emilio S." wrote: Hi, trying to figure out a formula to populate column c, where it would reflect the week of the month. This would be calculated off the value in column A. Please help. Thanks, Emilio A B C 11/1/2007 Thursday 1 11/2/2007 Friday 1 11/3/2007 Saturday 1 11/4/2007 Sunday 2 11/5/2007 Monday 2 11/6/2007 Tuesday 2 11/7/2007 Wednesday 2 11/8/2007 Thursday 2 11/9/2007 Friday 2 11/10/2007 Saturday 2 11/11/2007 Sunday 3 11/12/2007 Monday 3 11/13/2007 Tuesday 3 11/14/2007 Wednesday 3 11/15/2007 Thursday 3 11/16/2007 Friday 3 11/17/2007 Saturday 3 11/18/2007 Sunday 4 11/19/2007 Monday 4 11/20/2007 Tuesday 4 11/21/2007 Wednesday 4 11/22/2007 Thursday 4 11/23/2007 Friday 4 11/24/2007 Saturday 4 11/25/2007 Sunday 5 11/26/2007 Monday 5 11/27/2007 Tuesday 5 11/28/2007 Wednesday 5 11/29/2007 Thursday 5 11/30/2007 Friday 5 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Week Of Month
=weeknum() is part of the analysis toolpak in xl2003.
Tools|addins and check Analysis toolpak. Depending on if it's installed, you may need the distribution disk. Emilio S. wrote: Sandymann, thanks it worked. Teetless, i don't think excel has a "weeknum" function, or at least my version (2003) doesn't. But thank you! "Teethless mama" wrote: =WEEKNUM(A1)-WEEKNUM($A$1)+1 copy down as far as needed "Emilio S." wrote: Hi, trying to figure out a formula to populate column c, where it would reflect the week of the month. This would be calculated off the value in column A. Please help. Thanks, Emilio A B C 11/1/2007 Thursday 1 11/2/2007 Friday 1 11/3/2007 Saturday 1 11/4/2007 Sunday 2 11/5/2007 Monday 2 11/6/2007 Tuesday 2 11/7/2007 Wednesday 2 11/8/2007 Thursday 2 11/9/2007 Friday 2 11/10/2007 Saturday 2 11/11/2007 Sunday 3 11/12/2007 Monday 3 11/13/2007 Tuesday 3 11/14/2007 Wednesday 3 11/15/2007 Thursday 3 11/16/2007 Friday 3 11/17/2007 Saturday 3 11/18/2007 Sunday 4 11/19/2007 Monday 4 11/20/2007 Tuesday 4 11/21/2007 Wednesday 4 11/22/2007 Thursday 4 11/23/2007 Friday 4 11/24/2007 Saturday 4 11/25/2007 Sunday 5 11/26/2007 Monday 5 11/27/2007 Tuesday 5 11/28/2007 Wednesday 5 11/29/2007 Thursday 5 11/30/2007 Friday 5 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How t count by week whatever is with in the week (two criteria, ma | Excel Discussion (Misc queries) | |||
how many times a particular day of the week appears in a given month | Excel Discussion (Misc queries) | |||
Whats the Week of the Month? | Excel Discussion (Misc queries) | |||
PivotTable Group by Week and Month | Excel Discussion (Misc queries) | |||
calculate month from week number | Excel Worksheet Functions |