Formula to determine is something is due this week
Hi all -
I would like to calculate if something is due this week based on a target date in another cell.
I have tried this formula: =IF((TODAY() - [Week Of]1) - 7 > 0, "no", "yes")
This formula pull in a 'yes' for anything that is due in the next 7 days, which is not quite what I'm looking for.
Is it possible to determine if something is due just in the current week?
Thanks!
Andrea
Answers
-
Yes. You could incorporate a WEEKNUMBER function.
=IF(WEEKNUMBER([Week Of]@row) = WEEKNUMBER(TODAY()), "yes", "no")
-
This is perfect. Thanks, Paul!
-
-
I am trying to get my parent row 'On Site Helper" box to check if any children have activity in the current week. Right now I have a formula to check my "on site helper" box
=IF(AND(Start@row <= TODAY(), Finish@row >= TODAY(), COUNT(PARENT([Scope of Work]@row)) > 0), 1, IF(COUNTIF(CHILDREN(), 1) >= 1, 1))
If i sue this same formula in the parent row then is is always checked even when I have a gap in site activity.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!