Allow a cell to only be certain days of the month

Terracina · 10/08/19

I put together schedules that include public hearing dates that are typically certain days of the month , i.e. 2nd Tuesday, is there a way to assign this to a cell in my schedule? Currently I have to go to that point in my schedule and manually find the date and each time the schedule changes I have to make sure I update it.

Paul Newcome · 10/08/19

You cannot restrict a cell to specific dates, but depending on your specifics you may be able to write a formula that will automate the date.

You can also use formulas and helper columns to display help text, drive conditional formatting, send automatic update requests, or a combination thereof if an incorrect date is entered.

Andrée Starå · 10/09/19

Hi,

I agree with Paul.

A formula could probably be structured so that you then could use a filter or formula for those dates.

Would that work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Allow a cell to only be certain days of the month

Comments

Help Article Resources

Categories