Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by meniyk
at 2024-07-29 00:34:51
ModifyPoint:500 Replies:5 POST_ID:828631USER_ID:11496
Topic:
Microsoft Excel Spreadsheet Software;;Spreadsheet Software
Hi,
Good any.. looking for some quick any easy formula.
Is there a formula where can calculate the week number of current month by given a date. As you know, every month there difference week number. I know excel weeknum function can do this, however, it is not the desired output i need. What I need are as follows.
E.g
Given date output
1 Aug --> 1st week
5 Aug ---> 2nd week
2 Sep ---> 1st week.
thank you.
Good any.. looking for some quick any easy formula.
Is there a formula where can calculate the week number of current month by given a date. As you know, every month there difference week number. I know excel weeknum function can do this, however, it is not the desired output i need. What I need are as follows.
E.g
Given date output
1 Aug --> 1st week
5 Aug ---> 2nd week
2 Sep ---> 1st week.
thank you.
Expert: barry houdini replied at 2024-07-30 06:10:09
I know the question is answered (nice answer Duncanb7) but just as an alternative you can also get the same results with this formula
=INT((13+DAY(A1)-WEEKDAY(A1))/7)
regards, barry
=INT((13+DAY(A1)-WEEKDAY(A1))/7)
regards, barry
Expert: duncanb7 replied at 2024-07-29 01:49:39
it took one minute to finish , Thanks
Author: meniyk replied at 2024-07-29 01:47:43
Thank You Duncanb7
Expert: duncanb7 replied at 2024-07-29 01:04:30
If you apply the formula in B column
it will be
2013/7/1 1
2013/7/2 1
2013/7/3 1
2013/7/4 1
2013/7/5 1
2013/7/6 1
2013/7/7 2
2013/7/8 2
2013/7/9 2
2013/7/10 2
2013/7/11 2
2013/7/12 2
2013/7/13 2
2013/7/14 3
2013/7/15 3
2013/7/16 3
2013/7/17 3
2013/7/18 3
2013/7/19 3
2013/7/20 3
2013/7/21 4
2013/7/22 4
2013/7/23 4
2013/7/24 4
2013/7/25 4
2013/7/26 4
2013/7/27 4
2013/7/28 5
2013/7/29 5
2013/7/30 5
2013/7/31 5
2013/8/1 1
2013/8/2 1
2013/8/3 1
2013/8/4 2
2013/8/5 2
2013/8/6 2
2013/8/7 2
2013/8/8 2
2013/8/9 2
2013/8/10 2
2013/8/11 3
2013/8/12 3
2013/8/13 3
2013/8/14 3
2013/8/15 3
2013/8/16 3
2013/8/17 3
it will be
2013/7/1 1
2013/7/2 1
2013/7/3 1
2013/7/4 1
2013/7/5 1
2013/7/6 1
2013/7/7 2
2013/7/8 2
2013/7/9 2
2013/7/10 2
2013/7/11 2
2013/7/12 2
2013/7/13 2
2013/7/14 3
2013/7/15 3
2013/7/16 3
2013/7/17 3
2013/7/18 3
2013/7/19 3
2013/7/20 3
2013/7/21 4
2013/7/22 4
2013/7/23 4
2013/7/24 4
2013/7/25 4
2013/7/26 4
2013/7/27 4
2013/7/28 5
2013/7/29 5
2013/7/30 5
2013/7/31 5
2013/8/1 1
2013/8/2 1
2013/8/3 1
2013/8/4 2
2013/8/5 2
2013/8/6 2
2013/8/7 2
2013/8/8 2
2013/8/9 2
2013/8/10 2
2013/8/11 3
2013/8/12 3
2013/8/13 3
2013/8/14 3
2013/8/15 3
2013/8/16 3
2013/8/17 3
Accepted Solution
Expert: duncanb7 replied at 2024-07-29 00:45:29
500 points EXCELLENT
######A B
1 2013/7/29 =WEEKNUM(A1,1)-WEEKNUM(DATE(YEAR(A1),MONTH(A1),1))+1
Is that what you want ?
Duncan
1 2013/7/29 =WEEKNUM(A1,1)-WEEKNUM(DATE(YEAR(A1),MONTH(A1),1))+1
Is that what you want ?
Duncan
