I am looking to do a conditional formatting formula as follows:
In one cell someone can write a date based on that date it will auto populate 4 other boxes.
If a person types in a date 01/01/16 through 01/31/2016 into a cell the other four cells boxes will become:
<tbody>
</tbody>
<tbody>
</tbody>
If a person types in a date 02/01/16 through 02/29/16 the other four cells will become:
<tbody>
</tbody>
<tbody>
</tbody>
And so on for the months of the dates to follow, can anyone think of some formulas that could make this work, I’d really appreciate it, thank you!
In one cell someone can write a date based on that date it will auto populate 4 other boxes.
If a person types in a date 01/01/16 through 01/31/2016 into a cell the other four cells boxes will become:
| 01/25/16 |
<tbody>
</tbody>
| Jan | 2015 | Dec | 2015 |
<tbody>
</tbody>
If a person types in a date 02/01/16 through 02/29/16 the other four cells will become:
| 2/4/16 |
<tbody>
</tbody>
| Feb | 2015 | Jan | 2016 |
<tbody>
</tbody>
And so on for the months of the dates to follow, can anyone think of some formulas that could make this work, I’d really appreciate it, thank you!
