Formula to find last monday (tue, wedn, thu or friday) for a given month

M

Michele

Hi,
I need a formula to calculate the date of the last monday, tuesday,
wednesday, thursday or friday of a given month.
Can't seem to find the answer anywhere.

example:

day: wednesday (or corresponding nr)
month: 3
year: 2004

Result: 31/03/04


Who can help?

Thank you for reading and eventually answering my question.Back
 
J

Jonathan Rynd

(e-mail address removed) (Michele) wrote in
Hi,
I need a formula to calculate the date of the last monday, tuesday,
wednesday, thursday or friday of a given month.
Click to expand...

day: sunday=1, monday=2, etc.

endofmonth:
=EOMONTH(DATE(year,month,1),0)

lastweekday:
=endofmonth-WEEKDAY(endofmonth)+day-7*(WEEKDAY(endofmonth)<day)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to find last monday (tue, wedn, thu or friday) for a given month 5
=DATEVALUE 5
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
calculating the number of consecutive shifts in a 6 week schedule 3
Need IF statement to check if today is Monday, Wednesday or Friday 3
Using a common worksheet name in a SUM formula 2
Nth day of month of year 3
Calc Prorated Cost based on Specific Days in a Given Month & Year Range 3

Top