That's the formula I'm actually using:
=IF(WEEKNUMBER([Week Of]@row) = WEEKNUMBER(TODAY()), "not available ", "available ")
i used this formula to check the employees' availability for the current week,
the problem is that i have a start date and an end date for each specific work, using this formula I'm able to insert just the start date ([Week Of]@row) , in this way the formula doesn't consider the date when the job finish.
how can i insert both the start and the end date to have the exactly availability for this week of all the employees?