I want to enter a value from a cell if the start and end date fall within the current month. I've tried some if/and statements and other formulas, but I have been unable to get the solution for the below scenario:
Any help is greatly appreciated!
<tbody>
</tbody>
Any help is greatly appreciated!
Start Date | End Date | Percent | January |
1/31/2019 | 11/25/2019 | 20% | If A1 & B1 are within January then 20% |
<tbody>
</tbody>