LinkBack URL
About LinkBacks
Hello
As my title says, i need a formula to find Monday & Friday of the last week.
Any idea?
Hello
As my title says, i need a formula to find Monday & Friday of the last week.
Any idea?
Try this.......
For Friday
=TODAY()-WEEKDAY(TODAY())-1
For Monday
=TODAY()-WEEKDAY(TODAY(),3)
Last edited by sktneer; 05-08-2014 at 02:53 AM.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
For FridayFor MondayFormula:
=(TODAY())-WEEKDAY(TODAY())-1Formula:=(TODAY())-WEEKDAY(TODAY(),3)-7
Last edited by Saarang84; 05-08-2014 at 03:12 AM.
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
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks