3

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

Functionality
Industry
Department

Comments

Yes. You could incorporate a WEEKNUMBER function.

 

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

This is perfect. Thanks, Paul!