Asked by meniyk
at 2024-07-29 00:34:51
Point: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.
