Availability Formula
I/m actually using this formula to check the current week availability of the employees considering all the jobs' dates of the year in which they are involved:
=IF(AND(WEEKNUMBER([Start Date]3:[Start Date]11) = WEEKNUMBER(TODAY()), WEEKNUMBER([End Date]3:[End Date]11) = WEEKNUMBER(TODAY())), "not available", "available")
the problem is that the formula works only with a single start date and a single end date, doesn't work with the all range of dates
someone can helps me?
thanks
Answers
-
Hi @Filippo01
I may be able to help you with this. However the solution for this problem will require a little more then a single formula and it's depended of how you have your sheets constructed.
If you want to proceed with creation of this solution then this will require to share some screenshots and more detailed description of your system.
Let me know if you are interested and we will go from there.
Thanks!
Tomasz Giba
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!