synergy16
Active Member
- Joined
- Mar 17, 2016
- Messages
- 420
- Office Version
- 365
- Platform
- Windows
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.
hopefully that makes sense.