every other wednesday

D

David

I use this in H3 to hold the nearest Wednesday to today's date:

=TODAY()+3-WEEKDAY(TODAY(),2)

It holds until the next Monday, then updates by a week as desired (for now)
Is there a formula that will change it by 2 weeks?

What I'm trying to do is have a biweekly Wednesday paydate available a few
days before and beyond the actual target Wednesday in case I can't process
the range connected to it on that exact date.
 
D

David

Biff wrote
If I understand .... just add 14:

=TODAY()+3-WEEKDAY(TODAY(),2)+14
Click to expand...

Well, I guess I didn't explain myself clearly enough. Your offering changes
the date long before the target Wednesday. I want H1 to hold its Wednesday
date for two weeks: from current Monday until the Monday after it's
reached. i.e. 7/21 will change to 8/4 on 7/26 and hold until 8/9 when it
will change to 8/18.

=TODAY()+3-WEEKDAY(TODAY(),2) holds it for one week - Monday before thru
Sunday after.
Tried =TODAY()+10-WEEKDAY(TODAY(),2), but it changes a week too soon.
 
R

Ron Rosenfeld

Well, I guess I didn't explain myself clearly enough. Your offering changes
the date long before the target Wednesday. I want H1 to hold its Wednesday
date for two weeks: from current Monday until the Monday after it's
reached. i.e. 7/21 will change to 8/4 on 7/26 and hold until 8/9 when it
will change to 8/18.
Click to expand...

This formula would seem to do what you specify:

=A6-WEEKDAY(A6-1)+3+7*(MOD(A6-WEEKDAY(A6-1)+3,2)=0)

Substitute TODAY() for A6 after you've tested it.


--ron
 
D

David

Ron Rosenfeld wrote
This formula would seem to do what you specify:

=A6-WEEKDAY(A6-1)+3+7*(MOD(A6-WEEKDAY(A6-1)+3,2)=0)

Substitute TODAY() for A6 after you've tested it.
Click to expand...

Excellent!! Thanks.
 
Top