How to query and display data within the validity period of n business days

Function Analysis: to display data within n working days, consider:

1. you can add a validity period field for each piece of data. Only the data before the validity period is displayed during query. For example, if the validity period is seven days, the Data creation time is, the validity period of the seven working days is 2014-07-30. Display Data with a validity period before.

2. Consider holidays. For example, if the data creation time is, the validity period of the seven working days is 2014-05-12. If you do not have a holiday on October 1, 2, or 3, the seven valid working days are Sunday, October 1, October 1, October 1, October 2, and October 3.

3. There may be holidays from Monday to Friday, and remedial work on Saturday. The holiday information for each year is different, so it is necessary to use a table to maintain the annual holiday information.

How to implement query and display data within the validity period of n business days