Date question: calculated date + specific day of the week

[JulieH]

Hi! Your help is greatly appreciated!

• Bid openings are always on Wednesday.
• Advertisement dates can be any weekday.
• A project must be advertised for a minimum of four weeks (holidays, weekends not excluded).

I need to calculate a date, based on the (advertisement date) that is a *Wednesday* at least four weeks following the (advertisement date).

Can you help me? Thank you!

 

[jardenp]

Date in A1.

=IF(WEEKDAY(A1)<=4,A1-WEEKDAY(A1)+32,A1-WEEKDAY(A1)+39)

Format cell as date.

 

[jardenp]

And welcome to the board!

 

[Matty]

Welcome to the Board...

If your advertisement date is in B2, try:

=B2-WEEKDAY(B2+3)+35

Matty

 

[JulieH]

That is so cool!! Thanks guys! I am so impressed!