I just got question from one of my client that Scheduling Start Date & Scheduling End Date is not working as expected. Really I was answer-less and did some research. Here is my findings for you...!
Your page/content will only be visible for given time period for visitors if you specify Scheduling Start Date & Scheduling End Date. Scheduling Start Date & Scheduling End Date columns are available in library by default if you are using publishing site. Just you need to follow below listed steps to make it working.
- Go to library setting page.
- click on 'Manage item scheduling'.
- Tick mark 'Enable scheduling of items in this list'

- now create item/page into your library and specify Scheduling Start Date & Scheduling End Date as per your requirement.
- Now publish your content/page. (if you do not publish then it will not be available to visitors once specified time arrives so content should be published to make this working.)
- Content will go to 'Scheduled' state automatically one you publish it.
- Content will automatically be visible for given time period.
- Content will become a draft automatically once specified time passed.
Enjoy the day...!