WEEKNUMBER FORMULA

Filippo01

how can i calculate through a formula the availability of a person for the current week considering the range of all the start dates and end dates of the jobs in which he is envolved?

=IF(WEEKNUMBER([Start Date]@row) = WEEKNUMBER(TODAY()), "not available ", IF(WEEKNUMBER([End Date]@row) = WEEKNUMBER(TODAY()), "not available", "available"))

actually i use this formula but the problem is that this formula works just with one start date and one end date, while i have to consider a range of start dates and end dates

thanks

@Andrée Starå

Mike TV

@Filippo01

Try using an =IF(AND( formula. Within the AND you can put multiple logic statement criteria to classify what is needed for a true result.

Filippo01

thanks @Mike TV

are you able to create the formula for me ?

Filippo01

I @Mike TV are you able to write the formula for me ?

Genevieve P.

Hi @Filippo01

I believe I answered your same question in this other post, here:

https://community.smartsheet.com/discussion/94856/formula

If this thread is a different question, we will need to know exactly what it is you're looking for in order to put it together for you. This means it would be helpful to see a screen capture of your sheet and an example output, but please block out sensitive data.