Availability Formula

Filippo01

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

Tomasz Giba

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!