WEEKNUMBER FORMULA

Filippo01

I'm actually using this formula:

=IF(AND(WEEKNUMBER([Start Date]40) = WEEKNUMBER(TODAY()), WEEKNUMBER([Start Date]39) = WEEKNUMBER(TODAY()), WEEKNUMBER([Start Date]38) = WEEKNUMBER(TODAY()), WEEKNUMBER([Start Date]41) = WEEKNUMBER(TODAY()), WEEKNUMBER([Start Date]42) = WEEKNUMBER(TODAY())), "Not Available", "Available")

to check the employees' availability of the current week

I don't know why this formula return always available also when the start date week is the same to the current week (today week) in this case the formula has to returns not available but it doesn't work

someone can help me?

Mike TV

@Filippo01

Show a picture of your [Start Date] column on those row # ranges. The formula looks good to me so I'm guessing those dates in the [Start Date] column at those rows aren't from this week.