Hi,
Need a formula to show week number of the month and month number based on week number.
An excel file attached with necessary details.
Pl. help.
Thanks,
Nagesh.
Hi,
Need a formula to show week number of the month and month number based on week number.
An excel file attached with necessary details.
Pl. help.
Thanks,
Nagesh.
Deleted. I misread post #1
Last edited by mehmetcik; 05-25-2021 at 02:50 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
In A4
="wk-" & MOD(E4-1,4)+1 & " " &TEXT(DATE(2021,MONTH($C$4)+INT((E4-1)/4),1),"mmm-yy")
Copy to B and down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks