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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com