# Formula to determine is something is due this week

Options
✭✭✭✭✭
edited 12/09/19

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

• ✭✭✭✭✭✭
Options

Yes. You could incorporate a WEEKNUMBER function.

=IF(WEEKNUMBER([Week Of]@row) = WEEKNUMBER(TODAY()), "yes", "no")

• ✭✭✭✭✭
Options

This is perfect. Thanks, Paul!

• ✭✭✭✭✭✭
Options
• ✭✭✭✭
Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!