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

1. ## Calculate date based on number of weeks or months after start date

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.

SampleDates.xlsx

2. ## Re: Calculate date based on number of weeks or months after start date

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

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

3. ## Re: Calculate date based on number of weeks or months after start date

Assuming the second one needs to return a weekday (Monday to Friday) try this

=WORKDAY(EOMONTH(D3,D6-1)+1,-1)

4. ## Re: Calculate date based on number of weeks or months after start date

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.``

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1