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
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!