Formula Help

Occasional Contributor

Hi All,

I need help in creating a formula which will take a start date from column E and if that start date is in the current week that we are on then I need column I to  populate a message to say that that the particular task is starting this week. Once the week is over the message should disappear and what ever task is due to start in that week will then appear with start this week.

 

Thank you

1 Reply

@Harry2145 Could be as simple as:

=IF(ISOWEEKNUM(E2)=ISOWEEKNUM(TODAY()),"Starts this week","")