Allow a cell to only be certain days of the month

Terracina

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

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å

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