Calculate date based on number of weeks or months after start date

Please see attached sample file.

What is the formula to:
1. Return the date of the last weekday of the work week based on weeks gone since start date.
2. Return the date of the last weekday of the month based on months gone since start date.

Thanks in advance.

SampleDates.xlsx

Not sure how you're getting 27th by adding 2 weeks to 1st

Weeks =D3-WEEKDAY(D3+1)+(D5*7)
Months =EOMONTH(D3,0)

Thanks... these worked perfectly:

1. Return the date of the last weekday of the work week based on weeks gone since start date.

Please Login or Register  to view this content.

2. Return the date of the last weekday of the month based on months gone since start date.

Please Login or Register  to view this content.