# Return End of Month Date Based on Another Date Input

1. ## Return End of Month Date Based on Another Date Input

Hello,

need to take dates in one column and show the last business day within that month for each value in another column. Please forgive my lack of knowledge with Excel and help. Thank you.

2. ## Re: Return End of Month Date Based on Another Date Input

Good afternoon bcomrie

...and welcome to the forum!!

Try :
Formula:
`Please Login or Register  to view this content.`

HTH

DominicB

3. ## Re: Return End of Month Date Based on Another Date Input

Originally Posted by bcomrie
....the last business day within that month
Your formula will give the last day of the month, Dominicb, assuming business days are Monday to Friday then with date in A2 try this formula in B2 to get last business day

=WORKDAY(EOMONTH(A2,0)+1,-1)

If you want to exclude holidays as well as weekends then with list of holiday dates in H2:H10 change to

=WORKDAY(EOMONTH(A2,0)+1,-1,H\$2:H\$10)

4. ## Re: Return End of Month Date Based on Another Date Input

thanks guys, worked!

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