# Formula To return the MONDAY of current week

This is a discussion on Formula To return the MONDAY of current week within the Excel Questions forums, part of the Question Forums category; Hi, I am looking for a Formula that will return the Date of the Monday of the Current week IE ...

1. ## Formula To return the MONDAY of current week

Hi,

I am looking for a Formula that will return the Date of the Monday of the Current week IE every week it updates to the Monday of the current week

2. ## Re: Formula To return the MONDAY of current week

think this might do it

=DATE(YEAR(A1),MONTH(A1),DAY(A1) + 2-WEEKDAY(A1))

4. ## Re: Formula To return the MONDAY of current week

Assuming that you want the current day on a Monday but the previous Monday on any other day you could use

=A1-WEEKDAY(A1,3)

If you don't want/need today's date in A1 just put that in the formula

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•