CONTEXT:
Employees receive a bonus if they've worked a certain number of hours ONLY if they have not had more than a two week gap in their work history. Currently we just skim their pay history visually for any gaps--but this method, as expected, has lead to missing some gaps and falsely offering the bonus. Employees are paid each week (not bi-weekly).
QUESTION:
After exporting their pay history dates to excel, how can I highlight any dates where a gap of 14 days or more exists? I'm assuming I would use conditional formatting, but I can't figure how what formula to use.
EXAMPLE:
| Week Ending for Pay Check (A2-A19) |
| 12/28/2014 |
| 12/21/2014 |
| 12/14/2014 |
| 12/7/2014 |
| 11/30/2014 |
| 11/23/2014 |
| 11/16/2014 |
| 11/2/2014 |
| 10/26/2014 |
| 10/19/2014 |
| 10/12/2014 |
| 10/5/2014 |
| 9/28/2014 |
| 9/21/2014 |
| 9/14/2014 |
| 9/7/2014 |
| 8/24/2014 |
| 8/17/2014 |
