VBA to determine a resource's next available date

[AeroBB]

Hi I'm a VBA novice looking for a solution that must be obvious, but not to me!
I have a voluntary/charity resource that is only available on specified days of the week.
So set up simple 1-D array in the spreadsheet with True or False, starting at Monday... ending Sunday
This enables the user of the spreadsheet to alter the daily availability but not alter (mess about) with formulas or code
An individual requests a date and I am looking for the spreadsheet and/or VBA to offer the next possible available day.

For example item is only available Tuesday, Wednesday and Thursday's,
Individual requests a date some way in the future which is a Friday, offer date is therefore the following Tuesday.
How can this "Tuesday" date be "calculated"?

Robustness is key as the resource availability changes, e.g. no longer available on Wednesdays but now on Friday
So this would make the original request above now available on the requested day.
(Clearly any resultant date clashes would be require human intervention!)

Any help/assistance much appreciated
Chris

(fyi on Excel for Mac V15)