"next week"

[synergy16]

i have a build schedule that has a date category of "next 7 days" so i use =today()+7, but what i really want it to be is "next week" if i use the +7 its always going to "roll" 7 days but what i really want is for it to use =today() as a reference point and then tell me something has to be built on or before the following saturday. so for example, today is the 27th, i want the formula to say, it has to be built on or before Aug 6. and it would say that date all week until the it became the next sunday. so for example, that category would read "has to be built before Aug 6" (for this week) but when it becomes july 30, i want it to read "has to be built before Aug 13" for that entire week.

hopefully that makes sense.

 

[synergy16]

In that case try

=WORKDAY.INTL(D2-1,2,"1111011")

perfect, thank you very much!!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[synergy16]

You're welcome & thanks for the feedback.

Fluff, i have one more question with regards to dates. on the same scheduling sheet i have formulas that count days backwards from a ship date to a calculated start building date. they look like the following
=IF(S21="SHIPDATE REQ","SHIPDATE REQ",IF(F20="NO OPS",G21,G21-F20))

is there a simple way i can add some code to that formula that would push the resulting date to the following monday if the resulted date fell on a weekend?

 

[Fluff]

Maybe

=IF(S21="SHIPDATE REQ","SHIPDATE REQ",IF(F20="NO OPS",G21,workday(G21-F20-1,1)))

 

[synergy16]

Maybe

=IF(S21="SHIPDATE REQ","SHIPDATE REQ",IF(F20="NO OPS",G21,workday(G21-F20-1,1)))

perfect. thanks again

 

[synergy16]

perfect. thanks again

actually, now that im thinking about it. since im counting backwards it should be: if resulting date lands on a weekend push it to the preceding friday. otherwise if i push to the following monday the resulted start date will end up later than i need

 

[Fluff]

Change the -1 to +1 & the 1 to -1

 

[synergy16]

Change the -1 to +1 & the 1 to -1

cheers mate!!!

 

[Fluff]

My pleasure.