LinkBack URL
About LinkBacks
I'm trying to write a formula that will tell me when its week one or week two, week three and week 4 based on a given date of any month.
Anyone knows such a foirmula...Im using weekday formula but no luck.
I'm trying to write a formula that will tell me when its week one or week two, week three and week 4 based on a given date of any month.
Anyone knows such a foirmula...Im using weekday formula but no luck.
G3 has the date in
Please Login or Register to view this content.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
You probably need to define what week 1 and week 2 is (i.e. does the week start on Monday? How do you number the weeks when say, a Thursday is the 1st of a month)
http://www.excelforum.com/excel-form...-in-month.html
There are a bunch of options in that thread that may be of help.
Do you consider days 1 to 7 as week 1, 8 to 14 as week 2 etc? Or Monday to Sunday as week. Answer will be according to that.
Try using the weeknum function. If A1 contains date, then use the below formula to get the weeknumberFormula:
Please Login or Register to view this content.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Week just for a given month, maybe:
=WEEKNUM(A1)-WEEKNUM(A1-DAY(A1)+1)+1
Thanks much guys. great help...Will drink a beer sometime lol. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks