I have a month-long scheduling program. I would like to add a feature that allows users to select which days of the week to be displayed on this schedule. I would like to avoid using VB code, since i don't want to require users to have macros enabled. I would like to do this with a formula, but i am having some trouble with the formula, and i can use a bit of help. This is the idea i am having.
There is a field called First Day of Schedule (not shown), which we are requiring to be a Monday, and in this example is displayed on E2. We can use the TRUE/FALSE or 1/2 values in the formulas, as they are both dynamic based on the user selection of days.
Any and all help would be appreciated.
Thanks you,
Randy
There is a field called First Day of Schedule (not shown), which we are requiring to be a Monday, and in this example is displayed on E2. We can use the TRUE/FALSE or 1/2 values in the formulas, as they are both dynamic based on the user selection of days.
Any and all help would be appreciated.
Thanks you,
Randy
