Week Number (Thurs to Wed)
Hello. I have a file where the week number resets to "1" every time the first Monday of the next month is reached. The formula I have is:
=INT((6+DAY(A2+1-WEEKDAY(A2-1)))/7)
Our weekly timeline has been updated, and it is now Thursday to Wednesday, and I'm hoping you can help me edit this formula to reset the week number to "1" every time the first Thursday of the next month is reached.
Thank you.
Try:
=INT((6+DAY(A2+1-WEEKDAY(A2-1,13)))/7)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks