Formula to determine is something is due this week

Andrea Mayer

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

Paul Newcome

Yes. You could incorporate a WEEKNUMBER function.

 

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

Andrea Mayer

This is perfect. Thanks, Paul!

Paul Newcome

Happy to help!