How can I autofill a cell with the date of the last Monday?

[excelos]

Hello!

How can I autofill a cell with the date of the last Monday?

Thanks!

 

[steve the fish]

This one produces same day in today is a monday:

=TODAY()-WEEKDAY(TODAY(),3)

or this one the previous monday:

=TODAY()-WEEKDAY(TODAY()-2)

So it depends on what you want to do on a monday.

 

[alansidman]

=if(weekday(today())=1,today()-6,if(weekday(today())=2,today()-7,if(weekday(today())=3,today()-1,if(weekday(today())=4,today()-2,if(weekday(today())=5,today()-3,if(weekday(today())=6,today()-4,today()-5))))))

 

[excelos]

This one produces same day in today is a monday:

=TODAY()-WEEKDAY(TODAY(),3)

or this one the previous monday:

=TODAY()-WEEKDAY(TODAY()-2)

So it depends on what you want to do on a monday.

So the first one, tomorrow, will return 29/10? I don't have a way to verify that.

 

[steve the fish]

Yes it will. You could replace today() with a cell reference with tomorrows date in it if you wanted to check.

 

[mikerickson]

Try
=FLOOR(TODAY()-2, 7)+2