need to return date of Monday in current week

[kualjo]

I need a formula that will return the date of the Monday in the current week. I have tried INDEX/MATCH, but can't seem to put it together correctly. This can't really be that hard, can it? Appreciate any help.

 

[VoG]

Try

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

 

[T. Valko]

I need a formula that will return the date of the Monday in the current week. I have tried INDEX/MATCH, but can't seem to put it together correctly. This can't really be that hard, can it? Appreciate any help.

Assuming Monday is the first day of the week.

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

 

[kualjo]

That's it VoG! I knew it was something simple, and I'm just overthinking it again. Thanks!