WEEKNUMBER FORMULA

Filippo01

@Andrée Starå

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?

Paul McGuinness

HI @Filippo01

This should do the trick:

=IF(OR(WEEKNUMBER([Week Of]@row) = WEEKNUMBER(TODAY()), WEEKNUMBER([End Date]@row = WEEKNUMBER(TODAY()), "not available ", "available ")

I didn't know what the name of the column which contains your end date so just called it [End date], you will need to amend that in the formula for it to work.

Hope that helps

thanks

Paul