WEEKNUMBER FORMULA

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!