Hi everyone,
I am using this formula in my workbook which contains crewmembers. A list will be created with all members on board. Works as a charme.
=INDIRECT("'Crewlist'!C"&SMALL(IF(LEN(Crewlist!$C$2:$C$86)=0,"",ROW(ペewlist!$2:$86)),ROW(Crewlist!C2)))
Now I want to use the same kind of formula to create a list of crewmembers who sign off (go home for holiday) on a certain date TODAY()+1 (thats tomorrow), which is the day after today.
I copied this formula and changes some columns, but cant get it fixed.
Can anyone help me out please.
Bookmarks