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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!