Calculate Week beginning and Week ending date of CURRENT month only

[egrospeRP]

Hi Excel Gurus,

I'm trying to figure out a formula that will calculate the week beginning and week ending of a specific date BUT only the current month.

For example, 8/3/2018 has a week beginning of 7/29/2018 and a week ending of 8/4/2018. What formula can i use so that the week beginning date will return 8/1/2018 not 7/29/2018?

Similar with the week ending date... For example, 8/28/2018 has a beginning week of 8/26/2018 and week ending date of 9/1/2018. What formula can i use so that the week ending date will return as 8/31/2018 not 9/1/2018?

Thanks in advance!

 

[Joe4]

For a date in cell A1:

Week Start Date:
=MAX(A1-WEEKDAY(A1)+1,DATE(YEAR(A1),MONTH(A1),1))

Week End Date:
=MIN(A1+(7-WEEKDAY(A1)),EOMONTH(A1,0))

Does that seem to do what you want?

 

[egrospeRP]

That did the trick! thank you so much!

For a date in cell A1:

Week Start Date:
=MAX(A1-WEEKDAY(A1)+1,DATE(YEAR(A1),MONTH(A1),1))

Week End Date:
=MIN(A1+(7-WEEKDAY(A1)),EOMONTH(A1,0))

Does that seem to do what you want?

 

[Joe4]

You are welcome.
Glad I was able to help!