MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Topic starter
Hi,
I have some dates in some cells, I need a formula to find the preceeding monday.
For example if in a cell I had 03/05/11 (today) I need a formula that will output 02/05/11 (the last Monday preceeding).
Any ideas?
Posted : 03/05/2011 12:19 pm
=[cell_reference]-(WEEKDAY([cell_reference],3))
Posted : 03/05/2011 12:23 pm
=A1-((WEEKDAY(A1,2))-1)
EDIT: too slow. 😉 And I concede, ",3" is neater, but I like Monday=1 😛
Posted : 03/05/2011 12:23 pm
Topic starter
Thanks!
Posted : 03/05/2011 12:27 pm