Can anyone help me a formula. I want the formula to return the date of the last monday that just passed.... any help would be great.
thanks in advance
Can anyone help me a formula. I want the formula to return the date of the last monday that just passed.... any help would be great.
thanks in advance
Try:
=TODAY()-WEEKDAY(TODAY(),3)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
thank you !
will this reference the last monday on any day of the week, the only reason i ask as it look like you are subtracting 3 days from today.
Try replacing TODAY() in the formula with A1, i.e. this formula in B1
=A1-WEEKDAY(A1,3)
and then you can test various dates in A1
It will always give you the previous Monday, although on a Monday it will show that day's date - if you want the previous Monday in that circumstance try changing to
=TODAY()-WEEKDAY(TODAY()-2)
Audere est facere
Great - thanks for resolving this
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks